Home › Forum › General › Calculate Week No. › Re: Calculate Week No.
September 23, 2010 at 11:49 pm #5437
There is a function in the formula editor called Date Difference. It will return the value between two dates as either:
y – years
l – months
w – weeks
d – days
wd – working days
h – hours
m – minutes
s – seconds
If you want to know what week a day falls in (I am assuming that you are counting 52 weeks per year), use January 1 of the year as the first date and your target date as the second date. return the value in days and divide by 7 to get your result.