Jump to content

Excel help please


Scutts

Recommended Posts

Posted

Hi, I'm designing a basic rota for work using Excel and need some advice.

 

I have a "Week No" which uses a drop down list of 1-52. I then want to display the date that corresponds to that week no. i.e. if 1 is selected as the "Week No" from the drop down list, I would like the date "01/01/2008" displayed in another cell. If I selected 2 for the "Week No", then 08/01/2008 would be displayed.

 

I'm not an expert, so if anyone could point me in the right direction it would be much appreciated.

 

Thanks

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.