maybe an array like:
=IF(AND(G13="",H13<>""),1,IF(G13>1,H13-G13-SUM(--(ROW(INDIRECT(G13&":"&H13))=TRANSPOSE(Holidays)))))
press CTRL + SHIFT + ENTER to confirm
maybe an array like:
=IF(AND(G13="",H13<>""),1,IF(G13>1,H13-G13-SUM(--(ROW(INDIRECT(G13&":"&H13))=TRANSPOSE(Holidays)))))
press CTRL + SHIFT + ENTER to confirm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks