counting dates in Excel

M

Maria

I need Excel to take our "call dates" and project 120 days
from that call date into another cell

For example If my "call date" is on 04/09/04 I need Excel
to calculate 120 days from this date
 
C

Chewy667

Try this formula:

=VALUE(Call Date)+120

Make sure on the cell you enter this formula into you set the cell
format to date.
 
Top