Thread: Auto enter data based on formula in another cell?
View Single Post
 
Old 06-30-2017, 11:44 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
=IF(F4="","",IF(AND(F4>=TODAY()-305,F4<=TODAY()),"Up to Date","Past Due"))
Reply With Quote