Date calculation with Networkdays & holidays - formula is slightly off
Hi all,
Please see attached sample workbook where my formula for calculating the removal of public holidays appears to be slightly off. Minutes and seconds seem to be calculated fine, but days aren't. Not sure where I've gone wrong! Any help appreciated
Cheers!
is there any chance the expected date of delivery may be on weekends or national holidays or it will be purely on working day
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
what is your expected result in that cases and why can you explain
your expected date fall under public holiday then how to treat that day
Hi nflsales,
Sorry should have made that clearer! I was expecting the formula to take both weekends and the public holidays into account that
I've added to the Networkdays formula (in the Lookups worksheet). On further review, I can see that it actually has (I've gotten confused)! The formula works perfectly...
The "How many days difference?" column is showing how many WORKING DAYS difference, rather than how many actual days difference. Based on that, the formula is actually working
as it should be.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks