formula for month that is prior to actual

  • Thread starter Thread starter GoBonnieGo
  • Start date Start date
G

GoBonnieGo

I saw a question with this title on here and it's exactly what I want... but
the answer is too technical for me and I'm wondering if someone can simplify
it. Here's my problem:

Each month, my people fill in a claim for what they did last month. On top,
I have a cell that lists today's date with the formula =TODAY(). In the body
of the report, I need to list that the report is for the previous month/year.

Can you help?

Thanks,
Bonnie
 
The month previous to Today is:
=date(year(today()),month(today())-1,day(today()))

See if that does what you want.

Regards,
Fred
 
It is not clear to me exactly what you need your to display. Perhaps you can
make use of this formula (where I have assumed your date is in A1)...

="Report Period:"&TEXT(A1-DAY(A1), "mmmm")
 
GoBonnieGo said:
I saw a question with this title on here and it's exactly what I want... but
the answer is too technical for me and I'm wondering if someone can simplify
it. Here's my problem:

Each month, my people fill in a claim for what they did last month. On top,
I have a cell that lists today's date with the formula =TODAY(). In the body
of the report, I need to list that the report is for the previous month/year.

Can you help?

Thanks,
Bonnie

=TEXT(TODAY()-DAY(TODAY()),"mmmm")&" "&YEAR(TODAY()-DAY(TODAY()))
 
Here are a couple of formulas that will return the month & year for the
previous month from the date in A1:
=TEXT(IF(DAY(A1)<15,A1-20,A1-40),"mmmm yyyy")
=TEXT(EOMONTH(A1,-1),"mmmm yyyy")

You could use either of these like this:
="Reporting period is: " & TEXT(IF(DAY(A1)<15,A1-20,A1-40),"mmmm yyyy")

Three mmm's gives the 3-letter short form of the month name (Jan, Feb, etc.)

Hope this helps,

Hutch
 
I saw a question with this title on here and it's exactly what I want... but
the answer is too technical for me and I'm wondering if someone can simplify
it. �Here's my problem:

Each month, my people fill in a claim for what they did last month. �On top,
I have a cell that lists today's date with the formula =TODAY(). �In the body
of the report, I need to list that the report is for the previous month/year.

=TEXT(EDATE(TODAY(),-1),"mmm yyyy")

EDATE() returns the date the number of months in the second parameter
before (negative) or after(positive) the date in the first parameter.

TEXT() returns the value specified in the first parameter, as text
formatted as the second parameter. If you want the month's name in
full use "mmmm yyyy".

Alan Lloyd
 
Back
Top