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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Ndstc1" wrote in message ...
|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
|