How do I calculate EDATE using days not months?

[Guest]

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

 

[Dave Peterson]

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

=a1+56

 

[Guest]

Just use

=A1+(8*7)

where A1 is the Dec visit


Regards,

Peo Sjoblom

 

[Frank Kabel]

Hi
=A1+56