How do I calculate EDATE using days not months?

P

pshift

I want to calculate a next monitoring visit based on a start date:
e.g.: Monitoring Visit on 06 Dec 2004 with projected visit in 8 weeks (56
d). How do I calculate this with EDATE? I only have months....hope this
makes sense

Kindest regards
 
D

Dave Peterson

You can just add 56 to your date (and keep the results formatted as a date).

=a1+56
 
Top