Date: Auto text entry based on aging

  • Thread starter Thread starter Annabelle
  • Start date Start date
A

Annabelle

L17 contains the Status Date (mm/dd/yyyy). If the date in L17 is seven days
older than the date I've manually entered in B3, then M17 should read "Update
Needed"; if within seven days from B3, it should read, "Current".

I am unable to get my formulas to work. Are there any suggestions?
 
Sorry I got it the wrong way round, it should be as this

=IF(B3-L17>=7,"Update Needed","Current")
 
Back
Top