Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofill dates
Hi
I am making an excel roster and would like the dates to autofill as follows Monday Tuesday Wednesday Wednesday PM Thursday 05/06/2017 06/06/2017 07/06/2017 07/06/2017 08/06/2017 A E D C B 12/06/2017 13/06/2017 14/06/2017 14/06/2017 15/06/2017 B A E D C 19/06/2017 20/06/2017 21/06/2017 21/06/2017 22/06/2017 C B A E D 26/06/2017 27/06/2017 28/06/2017 28/06/2017 29/06/2017 D C B A E 03/07/2017 04/07/2017 05/07/2017 05/07/2017 06/07/2017 E D C B A So if I fill in the first date say in A2 is there a formula to autofill all the other dates. Many thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofill dates when 1 is entered in a cell | Excel Programming | |||
Generating dates Using Autofill | Excel Discussion (Misc queries) | |||
autofill on fixed dates | Excel Worksheet Functions | |||
Can autofill, as in months or dates, go to the end of the spreads | Excel Worksheet Functions | |||
autofill next sheet with next set of dates | Excel Worksheet Functions |