LinkBack URL
About LinkBacks
Create named ranges for the date intervals of start_dates and end_dates and use a CF ormula of
=SUMPRODUCT(--(start_dates<=A2),--(end_dates>=A2))
Create named ranges for the date intervals of start_dates and end_dates and use a CF ormula of
=SUMPRODUCT(--(start_dates<=A2),--(end_dates>=A2))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks