Date Formulas

  • Thread starter Thread starter Kim
  • Start date Start date
K

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?
 
Kim

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

Andy
 
Kim

Try

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

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

Wayne B
 
Back
Top