• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sunday Dates

Hi Faisal,

Not sure what you are after, can you give an example, or better still upload a file with what you have and what you want

kanti
 
When adding dates and allowing for weekends and holidays have a look at the Workdays.intl function
 
Hi Faisal ,

A straightforward formula such as :

=NETWORKDAYS($B10+$C10,$D10+$E10,$J$2:$J$10)

will give the difference between the Start Date and Start Time ( in B10 , C10 ) and the End Date and End Time ( in D10 , E10 ). You can add 1 to the above formula if you wish.

The problem was with your value in E10 , which was not a time value ; for a proper time value , the value should be between 0 and 1 ; this value was the integer 12.

Narayan
 
You must log in or register to reply here.
Back
Top