calculating due dates

[Guest]

I am trying to write a formula for a due date in the future.
The inspections are good for one year. I would like to know 30 days before
insp. due. can someone help me. Thanks

column a column h
last Insp.
11/29/06 due or not due

 

[Niek Otten]

=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))-30

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am trying to write a formula for a due date in the future.
| The inspections are good for one year. I would like to know 30 days before
| insp. due. can someone help me. Thanks
|
| column a column h
| last Insp.
| 11/29/06 due or not due
| --
| E. Hogan
|

 

[Guest]

Niek,

Thank you very helpfull.

I would also like to be able to use DUE or NOT DUE, IF the function result
is within 30 days of today.