# formula for month(s) prior to actual

1. ## formula for month(s) prior to actual

yesterday i asked for a formula that would give month and year prior to
actual based on excel time and date, and the answer i received worked. i
also need the formula(s) for months 2 and 3 prior to actual to provide data
in a 3 month trend (i.e. a report generated in december would provide data
for october and september as well). i can't figure out how to tweak the
formula from yesterday to work.

=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),0),"MMMYYYY")

2. ## Re: formula for month(s) prior to actual

Just subtract from the month

=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-1,0),"MMMYYYY")

will give you Oct2005

=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-2,0),"MMMYYYY")

Sep2005

and so on

--

Regards,

Peo Sjoblom

news:DE783A1C-7E8C-432E-AA75-2B1A1D515B24@microsoft.com...
> yesterday i asked for a formula that would give month and year prior to
> actual based on excel time and date, and the answer i received worked. i
> also need the formula(s) for months 2 and 3 prior to actual to provide

data
> in a 3 month trend (i.e. a report generated in december would provide data
> for october and september as well). i can't figure out how to tweak the
> formula from yesterday to work.
>
> =TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),0),"MMMYYYY")
>
>

3. ## Re: formula for month(s) prior to actual

=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-1,0),"MMMYYYY")

=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-2,0),"MMMYYYY")

--

HTH

RP
(remove nothere from the email address if mailing direct)

news:DE783A1C-7E8C-432E-AA75-2B1A1D515B24@microsoft.com...
> yesterday i asked for a formula that would give month and year prior to
> actual based on excel time and date, and the answer i received worked. i
> also need the formula(s) for months 2 and 3 prior to actual to provide

data
> in a 3 month trend (i.e. a report generated in december would provide data
> for october and september as well). i can't figure out how to tweak the
> formula from yesterday to work.
>
> =TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),0),"MMMYYYY")
>
>

4. ## Re: formula for month(s) prior to actual

Hi

Try
=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-n,1),"MMMYYYY")
Change n to 1, 2 and 3 respectively to get the previous months -1, -2, -3

Regards

Roger Govier

> yesterday i asked for a formula that would give month and year prior to
> actual based on excel time and date, and the answer i received worked. i
> also need the formula(s) for months 2 and 3 prior to actual to provide data
> in a 3 month trend (i.e. a report generated in december would provide data
> for october and september as well). i can't figure out how to tweak the
> formula from yesterday to work.
>
> =TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),0),"MMMYYYY")
>
>

5. ## Re: formula for month(s) prior to actual

right on. i love this discussion board. thank you so much.

"Peo Sjoblom" wrote:

> Just subtract from the month
>
> =TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-1,0),"MMMYYYY")
>
> will give you Oct2005
>
> =TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-2,0),"MMMYYYY")
>
> Sep2005
>
> and so on
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> news:DE783A1C-7E8C-432E-AA75-2B1A1D515B24@microsoft.com...
> > yesterday i asked for a formula that would give month and year prior to
> > actual based on excel time and date, and the answer i received worked. i
> > also need the formula(s) for months 2 and 3 prior to actual to provide

> data
> > in a 3 month trend (i.e. a report generated in december would provide data
> > for october and september as well). i can't figure out how to tweak the
> > formula from yesterday to work.
> >
> > =TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),0),"MMMYYYY")
> >
> >

>
>
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1