LinkBack URL
About LinkBacks
For counting Thanksgiving, assuming 4th Thursday in November, try this twist on Biff's suggestion
=SUMPRODUCT(--(TEXT(ROW(INDIRECT(A2&":"&B2)),"mmm-ddd-d")="Nov-Thu-"&{22,23,24,25,26,27,28}))
For counting Thanksgiving, assuming 4th Thursday in November, try this twist on Biff's suggestion
=SUMPRODUCT(--(TEXT(ROW(INDIRECT(A2&":"&B2)),"mmm-ddd-d")="Nov-Thu-"&{22,23,24,25,26,27,28}))
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks