=today() less one month
 

Hello,

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

Thanks
Jim

=today() less one month
 

=TEXT(EDATE(TODAY(),-1),"mmmm")
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jim" wrote:

Hello,

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

Thanks
Jim

=today() less one month
 

Hi,
=TODAY()-30

then do custom format for the cell using

mmmm

"Jim" wrote:

Hello,

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

Thanks
Jim

=today() less one month
 

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?

--
Daryl S


"Jim" wrote:

Hello,

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

Thanks
Jim

=today() less one month
 

But if today is the 31st of the month? Or if today is the 1st of March?
--
David Biddulph

"Eduardo" wrote in message
...
Hi,
=TODAY()-30

then do custom format for the cell using

mmmm

"Jim" wrote:

Hello,

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

Thanks
Jim