Date formula

  • Thread starter Thread starter Chris
  • Start date Start date
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.
 
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
 
Hi Chris!

You need to define "workweek number". You have 4 common different
systems:

See:
http://www.cpearson.com/excel/weeknum.htm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top