a function to find the previous date based on a given date, a range of dates, and a criteria range and a criteria
works a bit like a sumif formula 

Please Login or Register  to view this content.