If you count the weeks from the beginning of the year, today is really the start of the 53rd week. However, if you base it on a 52 week year, today is really Week 1 (the 53rd week and the 1st week overlap

If you count the weeks from the beginning of the year, today is really the start of the 53rd week. However, if you base it on a 52 week year, today is really Week 1 (the 53rd week and the 1st week overlap at times).

So to tweak it, you need to add a conditional statement to return a "1" if the week is "53"

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

'Syntax for DatePart:
'DatePart (Interval, Date, [FirstDayOfWeek, [FirstWeekOfYear]] )
'The FirstWeekOfYear argument can have one of the following settings.
'2 - Week that has at least four days in the new year (complies with ISO standard 8601, section 3.17)
'1 - Week in which January 1 occurs (default)
'0 - First week of year specified in system settings

Featured Post

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.

Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.
This l…