Hi!
I have this formula bellow that basically subtract two dates (only considering weekdays) and tells me how many days are between them. I also need to have the holidays subtracted
I have a named range with holidays (the name of my range is holidays) but I don't know how to subtract it here:
Could anyone help me? Thanks!!=Z7-P7-2*INT((Z7-P7+WEEKDAY(P7;3))/7)-MAX(0;WEEKDAY(Z7;3)-4)
Bookmarks