Scutts Posted March 29, 2008 Posted March 29, 2008 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.