counting dates in Excel

  • Thread starter Thread starter Maria
  • Start date Start date
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
 
Try this formula:

=VALUE(Call Date)+120

Make sure on the cell you enter this formula into you set the cell
format to date.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Count dates within a Month 4
Sumproduct with variation 1
Count forward x days from date 3
Count Between dates 11
Sumproduct with added days 2
sumproduct with additions to data 1
How do I add amounts referencing specific dates? 7
Time - By 8am the next morning 11

Back
Top