Template for calculating different number of days between 2 dates

D

Dr Bass56

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.
 
P

Pecoflyer

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

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

--
Pecoflye

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

*Adding your XL version* to your post helps finding solution faste
 
N

Niek Otten

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

number of months and days between two dates without approximation 3
How to calculate the number of days between two dates 3
Days between two dates? 1
Subtracting two cell dates and highlight if over due by a certain amount of days 0
Work Days 5
Date + X days excluding holidays 1
Number of work days between two dates entered into a user form text box 0
Count specific days in between dates 2

Top