- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Urgently! The number of days between two dates without exception from the list.
!It is necessary to count the number of days between two dates with the exception of the dates in the list.
NetWorkDays is not suitable because it excludes Saturdays and Sundays, and that if the company sometimes works on Saturday and Sunday.
That is, I need to calculate the days between two dates excluding dates only from my list.
- Tags:
- counting days
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
A possible approach would be to create a master calendar, flag the dates you want to include / exclude in your calculation.
Then count the flagged dates in the master calendar that fall between the two dates.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be like:
U convert you both dates in to number and deduct them.
And then take the count of days from ur list and again deduct from above result.
Sachin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
See the attachment, imagine that the 50 million lines
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
See the attachment, imagine that the 50 million lines
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be something like this with new column u can try:
=if(weend or holiday<=Date of code,(num(date of code)-num(date start)-count(weekend or holiday)))
Plss alter if condtn as per need.
Sachin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Anothr condion in else should be like:
Simple date of code- start date.
Sachin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
While u try u use num() on all date fileds n compare.
Sachin