Excel 2007 : Convert Weeknum to a date.

**jacarutu** · 03-30-2012, 09:13 AM

I have calculated the weeknum for a particular date but, they now want it to show the week commencing date.

i.e. week 15 begins 02Apr12.

So instead of showing week 15, I need to show 02Apr12. Week 16 would show 09Apr12. etc. etc.

My head exploded and I can't think of a way to do it. Forgive me, It is Friday.

Regards

Mike

**darknation144** · 03-30-2012, 09:18 AM

What is week 1?

**darknation144** · 03-30-2012, 09:20 AM

Because it will be what ever the first date is ="01/01/2012"+(15*7) but you first week obviously doesn't start 1/1/12

**Richard Buttrey** · 03-30-2012, 09:22 AM

Hi,

With the week number in A1,

=DATE(2012,1,2)+(A1-2)*7

Regards

**jacarutu** · 03-30-2012, 09:22 AM

Sorted, i just remembered.

=R2*7+DATE(YEAR(TODAY()),1,1)-WEEKDAY(R2*7+DATE(YEAR(TODAY()),1,1),2)+1

Works fine.

Need a beer to get my brain moving.

I will mark this as closed.

MIke