I want to count the number of days between two dates. I am currently using this formula:
where B1 is equal to a date.Please Login or Register to view this content.
I want to modify the code to exclude weekends and, if possible, holidays. I don't really care if it excludes holidays but if it can be done great. So for example if:
2/1/08 = Friday
2/2/08 = Sat
2/3/08 = Sun
2/4/08 = Mon
2/5/08 = "today"
then today()-2/1/08 should equal 2 days.
Thanks for any help.
Bookmarks