Auto month entry

**Tracyann** · 10-12-2011, 04:07 AM

On a spreadsheet I am working on I would like the month / year to enter automaticaly.

The month is to be the month previous to the month that I open the spreadsheet.

Example working on spreadsheet in October but report is for September data.

Would a IF formula work

The current formula is =TODAY() which pulls up current month I need it to put in the previous month.

Hope that makes sense.

Thanks in advance

**JBeaucaire** · 10-12-2011, 04:13 AM

This formula would display the "name" of the prior month:

=TEXT(EOMONTH(TODAY(),-1),"MMMM")

**Tracyann** · 10-12-2011, 04:16 AM

Thanks so much

works a treat

**MUSTAFAINE** · 10-12-2011, 04:18 AM

try this one,

=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-1,1),"mmmm")

Couldn`t see sorry

**Fotis1991** · 10-12-2011, 04:21 AM

Originally Posted by Tracyann

On a spreadsheet I am working on I would like the month / year to enter automaticaly.

The month is to be the month previous to the month that I open the spreadsheet.

Example working on spreadsheet in October but report is for September data.

Would a IF formula work

The current formula is =TODAY() which pulls up current month I need it to put in the previous month.

Hope that makes sense.

Thanks in advance

Good morning

Try this: =(MONTH(TODAY()))-1
I hope to be the answer yhat you are looking for.