Week number to date
Tony,
a bit long-winded, but very straight-forward
=TEXT(DATE(YEAR(TODAY()),1,1)-WEEKDAY(DATE(YEAR(TODAY()),1,1))+2+(7*B3),
"dddd dd-mm-yy") & " to " &
TEXT(DATE(YEAR(TODAY()),1,1)-WEEKDAY(DATE(YEAR(TODAY()),1,1))+2+(7*B3)+6,
"dddd dd-mm-yy")
You could store the repeated expressions in another cell to simplify it.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Tony Ramsden" wrote in message
...
How do I make my excel sheet indicate the actual start and finish
dates of a working week when the week number is inserted,( It would
also be nice to do the opposite and give a date and have the week
number shown but not imperative).. So
if I input the week number in B3
and hey presto..
The week dates shown in say C3 (& C4-C7 if necessary ), in the format
of
Monday dd-mm-yy To Sunday dd-mm-yy
Many thanks
Tony
|