Hello,
I'm trying to show a date in MM/DD format going across five cells that represent the days of the week. I want to calculate the correct date after entering a start date. For example:
I would modify the formula in cell B6 using the DATEVALUE formula by typing in a specific start date, such as:=DATEVALUE("6/30/2008")
I would then like cells E11:I11 to show:
E11: Mon,6/30
F11: Tues,7/1
G11: Wed,7/2
H11: Thurs,7/3
I11: Fri,7/4
I chose to use the DATEVALUE function because I read that it's easier to add dates when converted into their serial number equivalent. I would also like to do this without VBA, if possible. If I'm attempting this all wrong, feel free to point me to the right direction.
Appreciate the help!
Emil
Bookmarks