DATE & MONTH minus ?

Hello,
I have date in A_col and want minus month of B_col and want get result in
C_col

A B C
01-JUN-2006 -24 01- APR-2006

Thanks in advance.

01-JUN-2006 minus 24 month does not equal 01-APR-2006!

--
AP

"Tufail" <Tufail@discussions.microsoft.com> a écrit dans le message de news:
A7C809D4-77FD-4000-9D7A-EC781C7F3DDC@microsoft.com...
> Hello,
> I have date in A_col and want minus month of B_col and want get result in
> C_col
>
> A B C
> 01-JUN-2006 -24 01- APR-2006
>
> Thanks in advance.

=DATE(YEAR(A1);MONTH(A1)+B1;DAY(A1))


"Tufail" skrev:

> Hello,
> I have date in A_col and want minus month of B_col and want get result in
> C_col
>
> A B C
> 01-JUN-2006 -24 01- APR-2006
>
> Thanks in advance.

=DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1))

I am really very sorry for typing error, anyway i got reply thanks.

"Ardus Petus" wrote:

> 01-JUN-2006 minus 24 month does not equal 01-APR-2006!
>
> --
> AP
>
> "Tufail" <Tufail@discussions.microsoft.com> a écrit dans le message de news:
> A7C809D4-77FD-4000-9D7A-EC781C7F3DDC@microsoft.com...
> > Hello,
> > I have date in A_col and want minus month of B_col and want get result in
> > C_col
> >
> > A B C
> > 01-JUN-2006 -24 01- APR-2006
> >
> > Thanks in advance.
>
>
>

really thank you very much for your prompt reply even i typed wronglly.

"excelent" wrote:

> =DATE(YEAR(A1);MONTH(A1)+B1;DAY(A1))
>
>
> "Tufail" skrev:
>
> > Hello,
> > I have date in A_col and want minus month of B_col and want get result in
> > C_col
> >
> > A B C
> > 01-JUN-2006 -24 01- APR-2006
> >
> > Thanks in advance.