View Single Post
  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

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

=a1+56



pshift wrote:

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