Hello,

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

Thanks
Jim

=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

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

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

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