Date formula

C

Chris

Please help.
In cell B11 I enter the workweek number.
I would like the date that coincides with each week number
to automatically appear in cell B13.

I have 2 sheets in this workbook. Sheet 1 is the time
sheet and sheet 2 is the 2004 work calendar (which I'm not
sure is needed).

I tried using an IF formula in cell B13 and it worked for
1 week but not for multiple weeks.
 
A

Anne Troy

Hi, Chris. Very simple:

Put the date in A1.
Put this formula where you want the week to appear: =WEEKNUM(A1,1)

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
 
Top