Hey all,
I know there is a similar thread out there- but not quite what i'm after..
Basically I want to return a "True or False" if a date falls in between a date on another data tab. I also want that to only occur for certain data, based on a criteria of a unique ID number.
I currently have =SUMIFS(ID Range,ID range,ID number,Start Date Range,">="&Start Date,End date Range,"<="&End Date)>0
This only works if the the period is only one day, but doesn't populate "True" for anything with a multiple day date range.
Any ideas?
Thanks!
Bookmarks