=today() less one month

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Hello,

In a cell I would like to return last month, October. What is the formula
for this?

Thanks
Jim
 
Jim -

Depending on what you need...

This returns the last day of the month prior to the date you want
=(Today()-DAY(Today()))
If you format the cell with this formula as custom "mmmm", it will show you
the name of the month.

If you need the month number (as in a formula), then use this:
=Month(Today()-DAY(Today()))
which will return 10 for the 10th month, which is October.

Is either of these what you need?
 
But if today is the 31st of the month? Or if today is the 1st of March?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving range? 6
CF for next month/this year 3
Calculations for Quota by month 1
Being nosey 2
I don't need the actual value but what is shown 2
Help needed 0
Last day of last month 5
last entry in a range? 2

Back
Top