I am creating a spreadsheet for my local parish church to keep track of borrowed DVDs:
The DVDs have to be returned 14 days after they are borrowed. If the current date is over 14 days after the date borrowed then I would like the respective cell in the overdue column to show Yes; however if the DVD is returned, then the respective cell (in overdue column) should be blank. The formula I currently use is: =IF(D10<(TODAY()-14), "Yes","")
where D10 is the Date borrowed.
The problem with this formula is that "Yes" appears if the Date borrowed cell is blank and It continues to indicate "Yes" (in over due column) even if the DVD is returned.
Any feedback would be much appreciated.