Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating due dates
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating due dates
=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 | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating due dates
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. -- E. Hogan "Niek Otten" wrote: =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 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating With Dates | Excel Discussion (Misc queries) | |||
Calculating dates | Excel Discussion (Misc queries) | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
calculating dates | Excel Worksheet Functions | |||
calculating with dates | Excel Discussion (Misc queries) |