# Formula: Date plus 3 months

1. ## Formula: Date plus 3 months

Hiya, I have a date in cell A1 and I want to know a formula which will
calculate this date minus 3 months, in cell A2.

I've tried a simple "=A1-3month" but this doesn't work.

Any ideas?
--
Carly

2. ## Re: Formula: Date plus 3 months

Hi Carly

One way:

=DATE(YEAR(A1),MONTH(A1)-3,DAY(A1))

--
Best Regards
Leo Heuser

"Carly" <Carly@discussions.microsoft.com> skrev i en meddelelse
news:C8FE013B-C690-4AE9-9687-D655913069F2@microsoft.com...
> Hiya, I have a date in cell A1 and I want to know a formula which will
> calculate this date minus 3 months, in cell A2.
>
> I've tried a simple "=A1-3month" but this doesn't work.
>
> Any ideas?
> --
> Carly

3. ## RE: Formula: Date plus 3 months

With the Analysis Toolpak add-in installed use

=edate(a1,-3)

"Carly" wrote:

> Hiya, I have a date in cell A1 and I want to know a formula which will
> calculate this date minus 3 months, in cell A2.
>
> I've tried a simple "=A1-3month" but this doesn't work.
>
> Any ideas?
> --
> Carly

4. ## RE: Formula: Date plus 3 months

Thanks Duke. That one would be perfect, but I don't have the Analysis Toolpak

Any ideas of a work around?
--
Carly

"Duke Carey" wrote:

> With the Analysis Toolpak add-in installed use
>
> =edate(a1,-3)
>
>
> "Carly" wrote:
>
> > Hiya, I have a date in cell A1 and I want to know a formula which will
> > calculate this date minus 3 months, in cell A2.
> >
> > I've tried a simple "=A1-3month" but this doesn't work.
> >
> > Any ideas?
> > --
> > Carly

5. ## Re: Formula: Date plus 3 months

Thats done the trick; many thanks Leo!
--
Carly

"Leo Heuser" wrote:

> Hi Carly
>
> One way:
>
> =DATE(YEAR(A1),MONTH(A1)-3,DAY(A1))
>
> --
> Best Regards
> Leo Heuser
>
> Followup to newsgroup only please.
>
> "Carly" <Carly@discussions.microsoft.com> skrev i en meddelelse
> news:C8FE013B-C690-4AE9-9687-D655913069F2@microsoft.com...
> > Hiya, I have a date in cell A1 and I want to know a formula which will
> > calculate this date minus 3 months, in cell A2.
> >
> > I've tried a simple "=A1-3month" but this doesn't work.
> >
> > Any ideas?
> > --
> > Carly

>
>
>

6. ## RE: Formula: Date plus 3 months

Carly -

The Analysis Toolpak is standard with Excel. Go to Tools>Add-ins and check
it to isntall it. It gives you access to quite a variety of powerful
functions & is well woorth while.

"Carly" wrote:

> Thanks Duke. That one would be perfect, but I don't have the Analysis Toolpak
>
>
> Any ideas of a work around?
> --
> Carly
>
>
> "Duke Carey" wrote:
>
> > With the Analysis Toolpak add-in installed use
> >
> > =edate(a1,-3)
> >
> >
> > "Carly" wrote:
> >
> > > Hiya, I have a date in cell A1 and I want to know a formula which will
> > > calculate this date minus 3 months, in cell A2.
> > >
> > > I've tried a simple "=A1-3month" but this doesn't work.
> > >
> > > Any ideas?
> > > --
> > > Carly

7. ## Re: Formula: Date plus 3 months

I agree - It is very powerful - why isn't part of the standard functions -
is this due to the historical versions when the add-in was first developed?

"Duke Carey" <DukeCarey@discussions.microsoft.com> wrote in message
news:EE2D950E-2B5A-43B7-9272-CD19246FF6A1@microsoft.com...
Carly -

The Analysis Toolpak is standard with Excel. Go to Tools>Add-ins and check
it to isntall it. It gives you access to quite a variety of powerful
functions & is well woorth while.

"Carly" wrote:

> Thanks Duke. That one would be perfect, but I don't have the Analysis

Toolpak
>
>
> Any ideas of a work around?
> --
> Carly
>
>
> "Duke Carey" wrote:
>
> > With the Analysis Toolpak add-in installed use
> >
> > =edate(a1,-3)
> >
> >
> > "Carly" wrote:
> >
> > > Hiya, I have a date in cell A1 and I want to know a formula which will
> > > calculate this date minus 3 months, in cell A2.
> > >
> > > I've tried a simple "=A1-3month" but this doesn't work.
> > >
> > > Any ideas?
> > > --
> > > Carly

8. ## Re: Formula: Date plus 3 months

=A1-90

as in 90 (or whoever many) days?

--
------------------------------------------------------------------------

9. ## Re: Formula: Date plus 3 months

You're welcome, Carly, and thanks for the feedback :-)

LeoH

"Carly" <Carly@discussions.microsoft.com> skrev i en meddelelse
news:E21E5575-3EEC-416B-8FC6-133F7F3ED35B@microsoft.com...
> Thats done the trick; many thanks Leo!
> --
> Carly
>

10. ## Re: Formula: Date plus 3 months

Date functions in XL are a bit problematic.

With May 31, 2005 in A1 and with

=DATE(YEAR(A1),MONTH(A1)-3,DAY(A1))

in B1 the return date is March 3, 2005

I don't think that's what the OP really wants.

Using the edate from the analysis toolpack as someone else suggested may be
better.

"Leo Heuser" <leo.heuser@NOSPAMadslhome.dk> wrote in message
news:u3r2aGJXFHA.2348@TK2MSFTNGP14.phx.gbl...
> Hi Carly
>
> One way:
>
> =DATE(YEAR(A1),MONTH(A1)-3,DAY(A1))
>
> --
> Best Regards
> Leo Heuser
>
> Followup to newsgroup only please.
>
> "Carly" <Carly@discussions.microsoft.com> skrev i en meddelelse
> news:C8FE013B-C690-4AE9-9687-D655913069F2@microsoft.com...
> > Hiya, I have a date in cell A1 and I want to know a formula which will
> > calculate this date minus 3 months, in cell A2.
> >
> > I've tried a simple "=A1-3month" but this doesn't work.
> >
> > Any ideas?
> > --
> > Carly

>
>

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