Dr Bass56;265260 Wrote:
Does anyone have a template to calculate the number of days between two
dates.
I work in Realestate and we often get MEC (Mutual Execution of
Contract) +
40 days, etc in our contracts. Holidays and weekends are excluded.

Hi,
have you have a look at the WORKDAYS function ?
( I think it's part of the Analysis Toolpak)


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=74032