![]() |
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. |
All times are GMT +1. The time now is 02:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com