200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Hi
I need your experites help to solve the problem.
I have an excel file and every day updating it.
for example:
Cell A1 contains date(any date)
I want cell A3 to indicate any type of indication such
red dot or x symbol or any indication if A2 is
blank after 10 days of the date in A1.
If A2 is filled, A4 will indicate green dot or any other
indication.
the data of A1 and A2 is date. It can be any date weather today date or old date of future date.
I think this formula might be what you are looking for:
=IF(NOT(ISBLANK(A2)),"O",IF(AND(TODAY()-A1>10,ISBLANK(A2)),"X",""))X is for the red dot.
O is for the green dot.