Template for calculating different number of days between 2 dates
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. |
Template for calculating different number of days between 2 dates
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 |
Template for calculating different number of days between 2 dates
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. |
All times are GMT +1. The time now is 04:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com