J
Jim
Hello,
In a cell I would like to return last month, October. What is the formula
for this?
Thanks
Jim
In a cell I would like to return last month, October. What is the formula
for this?
Thanks
Jim
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Luke M
=TEXT(EDATE(TODAY(),-1),"mmmm")
E
Eduardo
Hi,
=TODAY()-30
then do custom format for the cell using
mmmm
=TODAY()-30
then do custom format for the cell using
mmmm
D
Daryl S
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?
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?
D
David Biddulph
But if today is the 31st of the month? Or if today is the 1st of March?