Originally posted by: McVicar

Today is Monday 4th November 2019. I believe this is Week 45 of the year.

However if I code the following -

=FROMDATETIME(CURRENTDATE(),"{WW}"  )

then I get 44 output, not 45.

Tomorrow (Tuesday) if I run it again I will get 45  !!

Surely the weeks do not start on a Tuesday?

Am I missing something?

Thanks in advance for any advice on this.

Originally posted by: PaulBrett

Hi,

2019 begins on a Tuesday.  The first 7 days (Tuesday to Monday) are week 1.

I think the answer you got was right.  (See attached map)

Thank you.

Paul

Follow me on Twitter

Attachment(s)

WeekNumbers.zip   7 KB 1 version

Originally posted by: McVicar

Thanks Paul for the reply, yes I can see how that works, just not necessarily how I'd expected it to!