Hello
I am trying to create a scheduling calendar.
I enter the Monday's date for the week in cell B3 - I want it to return the "day of week and date"
for example:
Mon - 12/12/15 in cell b5
Tue - 12/13/15 in cell f5, etc...for Wed, Thu, and Fri
Is there a simple formula to accomplish this?
A3 B3
Date: 10/12/2015
A5 B5 C5 D5 E5 F5 G5 H5 I5 J5
Time Mon 10/12/15 Type Div Loc Tue 10/13/15 Type Div Loc
8:00 - 8:20
8:20 - 8:40
8:40 - 9:00
9:00 - 9:20
9:20 - 9:40
9:40 - 10:00
I am trying to create a scheduling calendar.
I enter the Monday's date for the week in cell B3 - I want it to return the "day of week and date"
for example:
Mon - 12/12/15 in cell b5
Tue - 12/13/15 in cell f5, etc...for Wed, Thu, and Fri
Is there a simple formula to accomplish this?
A3 B3
Date: 10/12/2015
A5 B5 C5 D5 E5 F5 G5 H5 I5 J5
Time Mon 10/12/15 Type Div Loc Tue 10/13/15 Type Div Loc
8:00 - 8:20
8:20 - 8:40
8:40 - 9:00
9:00 - 9:20
9:20 - 9:40
9:40 - 10:00