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.

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

Look in HELP for the WORKDAY() and NETWORKDAYS() functions

Pay attention to the instructions for a #NAME result, if applicable

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dr Bass56" <Dr wrote in message
...
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.