Thread
:
Auto enter data based on formula in another cell?
View Single Post
06-30-2017, 08:06 AM
ddansie
Windows 7 32bit
Office 2013
Novice
Join Date: Jun 2017
Location: Utah
Posts: 6
Maybe us a nested IF statement
Have you tried using a nested IF statement?
=IF(A1>=TODAY()-305,"Up to Date","Past Due")
ddansie
View Public Profile
Find all posts by ddansie