Hi,
I am having some issues getting a formula to work.
I have column L as a required handover date for a product, I want the next column to return "chase" if that date in L is within 3 days of the current date + 7 days.
Current formula as follows:
=IF(L14-TODAY()+7<=3,"Chase","")
The cell returns as blank if there is any date in column L and says "chase" when L is blank.
Any ideas?
Thanks
Bookmarks