DATE & MONTH minus ?

[Guest]

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.

 

[Ardus Petus]

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

 

[Guest]

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


"Tufail" skrev:

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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