Formula for previous working week number

**mtt23** · 01-07-2013, 06:38 AM

Hi,

Does anyone have a formula that calculates the previous week number?
The one I use for the current week number is:
=1+INT((TODAY()-(DATE(YEAR(TODAY()),1,2)-WEEKDAY(DATE(YEAR(TODAY()),1,1))))/7)

Although Im not 100% sure how to alter this.
Do I have to change the '=1+INT' part to '=0+INT' ??

Thank you in advance!

**Fotis1991** · 01-07-2013, 06:42 AM

Maybe

=1+INT((TODAY()-(DATE(YEAR(TODAY()),1,2)-WEEKDAY(DATE(YEAR(TODAY()),1,1))))/7)-1

**mtt23** · 01-07-2013, 06:45 AM

Originally Posted by Fotis1991

Maybe

=1+INT((TODAY()-(DATE(YEAR(TODAY()),1,2)-WEEKDAY(DATE(YEAR(TODAY()),1,1))))/7)-1

Hi Fotis,

Unfortunately that is the formula that is giving me a problem. Because, last week that formula gave me week number '0' when it should have been week '52'.

Because it takes the current week, (which was week 1), then -1, giving 0.

Any other solutions?

**Ace_XL** · 01-07-2013, 06:45 AM

Maybe..

Please Login or Register  to view this content.

**mtt23** · 01-07-2013, 06:52 AM

But when it comes to week 1 again, wouldn't that just give me week 0 instead of 52?

**Ace_XL** · 01-07-2013, 06:59 AM

In that case use

Please Login or Register  to view this content.

**mtt23** · 01-07-2013, 07:05 AM

Thank you very much ACE!

**daddylonglegs** · 01-12-2013, 02:09 PM

Old question, I know but the week number of the last day of 2012, as defined by WEEKNUM function, was 53 not 52 (and sometimes you can get 54). If you simply want the week number from the end of the last year you could try this:

=IF(WEEKNUM(TODAY())=1,WEEKNUM(TODAY()-DAY(TODAY())),WEEKNUM(TODAY())-1)