Hi All,
Can anyone please advise how to fill dates between 2 static dates using the latter date as a max date.
i.e.
Input
A1: 10/03/18
B1: 10/03/19
Output
Range
A10 = 10/03/18, C10 = 11/03/18, E10 = 12/03/18, G10 = 01/03/19, I10 = 02/03/19, K10 = 03/03/19, M10 = 04/03/18
O10 = 05/03/19, Q10 = 06/03/19, S10 = 07/03/19, U10 = 08/03/19, W10 = 09/03/18, Y10 = 10/03/19
I also need this be be flexible...
If the date in B1: is for example 10/03/20 then I need the cells to continue the patter and repeat 7 across (with a 1 column interval) by (n) rows down as above.
Any help please
Thanks