Date Formulas

[Kim]

Does anyone know how to formulate a date so that it
caculates 30 days out from an already existing date? For
example, column A2 has a job date of 9/3/03. I need
Column B2 to count 30 business days and put that date in
that column then remind me when it's past due. Can Excel
do this?

 

[Andy B]

Kim

Try using NETWORKDAYS(). This also gives you the facility to state holidays.

Andy

 

[StarTrek an beyond]

Kim

Try

=IF(((A1+30)>31),"PAST DUE","")

with Conditional Formatting to make the cell or font color red.

Wayne B