Auto text entry based on aging
Sorry I got it the wrong way round, it should be as this
=IF(B3-L17=7,"Update Needed","Current")
"Howard31" wrote in message
...
Enter the following formula in cell M17
=IF(L17-B3=7,"Update Needed","Current")
"Annabelle" wrote in message
...
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?
|