ExcelBanter - DATE & MONTH minus ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - DATE & MONTH minus ? (https://www.excelbanter.com/excel-programming/363894-date-month-minus.html)

Tufail

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.

Ardus Petus

DATE & MONTH minus ?

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

--
AP

"Tufail" a écrit dans le message de news:
...
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.

excelent

DATE & MONTH minus ?

=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.

excelent

DATE & MONTH minus ?

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

Tufail

DATE & MONTH minus ?

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" a Ã©crit dans le message de news:
...
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.

Tufail

DATE & MONTH minus ?

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.

All times are GMT +1. The time now is 07:31 AM.