Microsoft Excel Days and Dates: Solved
Part One
Download Free Solution Here: Days
I wish to be able to enter a day of the week into one cell for example
A1 = Wednesday
and when I enter that day the day will appear in Cell (eg) E4 but then I want that E5 is the following day and E6 follows on from that
So if I enter Wednesday into A1
E4 will read Wednesday
E5 will read Thursday
E6 Will read Friday
E7 will read Saturday
E8 Will Read Sunday
and so on and then re-starts back to Monday and so on
But I do not want any day to show up in E1 to E3 if Wednesday was the first day of the week.
Download Free Solution Here: Days
Part two
Download Free Solution Here: Dates
I enter a date number in cell B1
I wish to have that date enter in Cell F5
Example Cell B1 Reads 1
Cell F5 should read 1
Cell F6 should read 2
Cell F7 reads 3 and so on
But the Cells may start from F1 through to F40 so If the number 1 goes into F7 I want F1 to F6 to remain blank but I want F8 to read 2 and F9 to read 3 and so on
Also can I allow for a leap year?
Download Free Solution Here: Dates