insert month

[pvwebster]

I have 12 sheets (one for each month) and want to set things up so I only need to insert the date (i.e 1 January 2018) on the first sheet and then all other sheets are automatically updated with 1 February 2018, 1 March 2018 and so on. I am sure I have done it before but for the life of me cannot remember how I did it.

Update: sorry I cant see how to delete this post. I remember the solution to my problem, I used EDATE to add the following months i.e. =EDATE(JAN!A5,1)

Cheers

Paul

[Glenn Kennedy]

What do you mean by automatically updated??? What do you want and where?

[Glenn Kennedy]

If you mean you are entering 01/01/2017 in A1 of the Janbuary sheet and you want 01/02/2017 on the February sheet, then in February A1, use

=EDATE(January!A1,1)

and 2 in the March sheet, 3 in the April sheet, etc.