View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ElFrodo ElFrodo is offline
external usenet poster
 
Posts: 12
Default Use year and weeknr to find date??

Is there a formula to automatic fill out the right corresponding dates, or
other ways to do it??
I.e.
a1=2007 (year)
b1= 2 (week nr)

and in c1-c7 i want it to automaticly to say 8, 9, 10 and so fort.

Can enyone help me??