ContributionsMost RecentMost LikesSolutionsRe: Duration formula that only counts Monday-Saturday, excludes Sundays.The current formula that I am using is: ToDays([To Date]-[From Date])+1 It would be nice to be able to exclude Sunday's if possible, so in this example it would only show 7 days taken off instead of 8. Another example would be if someone took off from 1-12-21 to 1-26-21 it would show 13 days were take off since two Sundays were in the timeframe. ------------------------------ Daniel Fuhriman ------------------------------ Re: Duration formula that only counts Monday-Saturday, excludes Sundays.Yes. I am working on an app that tracks time off request. We are wanting to know what the difference is between two dates excluding Sundays. I am not sure if this is possible or not, but to complicate matters worst. The manager only wants to count Saturdays off as a half a day. If this 2nd step is not do able, the first request is fine. ------------------------------ Daniel Fuhriman ------------------------------ Duration formula that only counts Monday-Saturday, excludes Sundays.Hi! I was wondering if anyone knew a duration formula that only counts Monday- Saturday, excluding Sundays? I am aware of the formula WeekdaySub that counts only weekdays. Any help would be appreciated. Thanks, Dan ------------------------------ Daniel Fuhriman ------------------------------ Re: Duration formula that doesn't show negative #'sIt worked! Thanks for giving me such a positive first experience on this site Mark! Duration formula that doesn't show negative #'sHi! I was wondering if there is a way to run a duration formula between two dates, and only have it show the result in days if the answer is >= 0? This is what I am using now:[Bid Submission Date]-Today() Here is my result