WEEKNUM across multiple years

[jonbowles84]

Hi There,

Is there a simple solution to get a WEEKNUM count across more than 1 year?

Thanks

[Marc_Dillon]

What does that mean?

[jonbowles84]

WEEKNUM gives a number 1 to 53 depending on the week number of the year in question. Im wondering if there is a simple solution to subtract WEEKNUM("03/16/1962")  from WEEKNUM([Today])  for example

[Marc_Dillon]

Sure.

WEEKNUM([Today]) - WEEKNUM("03/16/1962")

[jonbowles84]

= 7

[TeeSee1 · Accepted solution]

You mean something like this??

HOUR(DATE1 - DATE2)/(24*7)

[jonbowles84]

Yeah, that'll do it! thanks 🙂 

[Marc_Dillon]

Wow, that's what you meant by "WEEKNUM across years"?!

whoosh...

I would describe that as "duration, in weeks, between 2 dates"

[jonbowles84]

Yeah, whoosh, thanks