auto entry of month

  • Thread starter Thread starter The Scho
  • Start date Start date
T

The Scho

I want to have three columns that are automatically titled
as the current month, the month prior and then two months
prior (in "Mon-YR" format). I want the spreadsheet to auto
update as a new month starts.

Example as of today would have:

Jan-04 -- Feb-04 -- Mar-04


Example as of April first:

Feb-04 -- Mar-04 -- April-04

The columns will be filled with simple data so, as the
month changes, the data must slide with the column it
belongs to.

Thanks
 
Hi
enter the following:
A1:
=DATE(YEAR(TODAY()),MONTH(TODAY())-2,1)
B1:
=DATE(YEAR(TODAY()),MONTH(TODAY())-1,1)
C1:
=DATE(YEAR(TODAY()),MONTH(TODAY()),1)

format all cells with your custom format MMM-YY

Don't understand what you mean with 'slide'
 
Thanks!

Slide means that the spreadsheet will update as the month
changes, showing only this month, last month and the month
prior. I want to automate this process. Date will be
entered under the appropriate month and the data from
the "outgoing" third month needs to be deleted as the 3rd
month becomes the now deleted 4th month.

Thanks again!
 
Back
Top