Dates

[erodri02]

I am working on a spreadsheet that consists of a rolling 12 mont
period. Once a month has passed how do I delete it and add a new mont
to the 12 month period? Please help

 

[Otto Moehrbach]

You have to provide more info on how your data is laid out. Tell us what
you have and tell us what you want to have when the month changes. HTH
Otto

 

[J.E. McGimpsey]

Perhaps you could explain your setup a bit more. I don't know how to
delete a month, though some months I'd like to try. Do you want to
delete a worksheet? a column of cells? A row of cells?

 

[erodri02]

Well this is how i have it laid out:

12/03-------------Months in between-------------------->11/04

Now once the month of December is over and January comes in I want m
row to read:

01/04-------------Months in between--------------------->12/04

As a month comes to an end I want to drop it shift over the months i
between and add a following month at the end. So I will always have a
updated 12 month look. Hope this is much more clearer. Please help

 

[J.E. McGimpsey]

You might choose to put this in the first cell:

A1: =TODAY()

Format it as

Format/Cells/Number/Custom mm/yy

then in subsequent cells:

B1: =DATE(YEAR(A1),MONTH(A1)+1,1)

format it similarly, and copy it over to L1.

The months will update automatically when the new month arrives.

 

[erodri02]

J.E. McGimpsey thanks for all your help. Code works great