4 Replies Latest reply on Mar 9, 2018 12:02 PM by arvindgarg

# date from week #, month and year

I have Week Number (starting on Sunday always), Month and year

I need to convert it to a Date

any ideas?

I was thinking something like this

DATE(str([Month])+"/1/"+str([Year]))

but how do I work the week number in?

• ###### 1. Re: date from week #, month and year

Below formula should work

DATE("01"+"01"+str([F Year]) # this gives you first of year  i.e. 1 jan 2017 .

Then we add weeks to this value

• ###### 2. Re: date from week #, month and year

I must be missing something, here is what I am getting

• ###### 3. Re: date from week #, month and year

See Calculation3 in the attached.  (Calc1->calc2->Calc3) is a progression of how I arrived at Calc3.)

• ###### 4. Re: date from week #, month and year

i think i pasted the wrong screenshot there.

But let me ask. When should be the date for below values?

The First week of year never comes in March

Mar 2017 OR Mar 2018 does not have 5 Sundays.