Autofill Dates between 2 static dates

  • 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

  • Hello,


    Can you upload a sample file with your desired results?

    [SIZE=4]"I don’t pretend we have all the answers. But the questions are certainly worth thinking about."
    Sir Arthur C. Clarke
    [/SIZE]

  • Hi and thank you for the repsonse.


    I should have closed this as I found a differet approach to a solution.


    Sorry if I have wasted any of your time.
    Thanks

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!