Microsoft Office Forums - View Single Post - Auto enter data based on formula in another cell?

Thread: Auto enter data based on formula in another cell?

View Single Post

Old

06-30-2017, 08:06 AM

ddansie

ddansie is offline

ddansie uses Windows 7 32bit

Windows 7 32bit ddansie uses Office 2013

ddansie uses Office 2013

Office 2013

Novice

Join Date: Jun 2017

Location: Utah

Posts: 6

ddansie is on a distinguished road

Default

Maybe us a nested IF statement

Have you tried using a nested IF statement?
=IF(A1>=TODAY()-305,"Up to Date","Past Due")

Reply With Quote