Hi There,
Is there a simple solution to get a WEEKNUM count across more than 1 year?
Thanks
Solved! Go to Solution.
What does that mean?
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
Sure.
WEEKNUM([Today]) - WEEKNUM("03/16/1962")
= 7
You mean something like this??
HOUR(DATE1 - DATE2)/(24*7)
Yeah, that'll do it! thanks ๐
Wow, that's what you meant by "WEEKNUM across years"?!
whoosh...
I would describe that as "duration, in weeks, between 2 dates"
Yeah, whoosh, thanks
User | Count |
---|---|
35 | |
31 | |
30 | |
19 | |
18 |