Re: Calculate Week No.

Home Forum General Calculate Week No. Re: Calculate Week No.

#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.