formula for month that is prior to actual
in [Functions]
|
Prev: Latest Purchase Price
Next: Trending Function?
From: GoBonnieGo on 4 May 2010 16:28 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
From: Fred Smith on 4 May 2010 16:42 The month previous to Today is: =date(year(today()),month(today())-1,day(today())) See if that does what you want. Regards, Fred "GoBonnieGo" <GoBonnieGo(a)discussions.microsoft.com> wrote in message news:D8137166-3480-4671-8A61-135EFC7743BB(a)microsoft.com... >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
From: Glenn on 4 May 2010 16:46 GoBonnieGo wrote: > 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()))
From: Rick Rothstein on 4 May 2010 16:44 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") -- Rick (MVP - Excel) "GoBonnieGo" <GoBonnieGo(a)discussions.microsoft.com> wrote in message news:D8137166-3480-4671-8A61-135EFC7743BB(a)microsoft.com... > 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
From: Tom Hutchins on 4 May 2010 16:57
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 "GoBonnieGo" wrote: > 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 |