FlorianT.
FlorianT.

Reputation: 873

Previous month with month name in google sheets

I have a month "August" and need a formula that gives me the name of the month before.

=TEXT(EDATE("August"; -1); "MMMM")

This does not work, as EDATE expects a DATE(). Can anyone advice?

Upvotes: 8

Views: 20040

Answers (2)

ILLEST
ILLEST

Reputation: 121

All you need is the following formula:

=text(EDATE(today();-1); "MMMM")

Upvotes: 12

sr3z
sr3z

Reputation: 410

if you can use month as a number, I would recommend you

=TEXT(EDATE(DATE(2016, 8, 1); -1); "MMMM")

for example

If not

=TEXT(EDATE(DATE(DATEVALUE("August 01, 2016")); -1); "MMMM")

Upvotes: 9

Related Questions