Column A,B and C are dates Condition:
If column A date is present use the same date. If date in A column is blank then use date from column B. If column B is blank then use date from column C.
C has the final date.
Asked
Active
Viewed 234 times
0
-
1Does this answer your question? [Is there a coalesce-like function in Excel?](https://stackoverflow.com/questions/20103881/is-there-a-coalesce-like-function-in-excel) – Mureinik Aug 31 '21 at 11:30
-
=IF(ISBLANK(A1),B1,A1) something like this, but nested more conditions – prickypineapple Aug 31 '21 at 11:33
1 Answers
1
Try this:
=IF(A1=TODAY(),A1,IF(A1="",B1,IF(B1="",C1)))
Rajput
- 605
- 3
- 12
-
I wanna compare dates from previous month so what function other than today can I use? – prickypineapple Aug 31 '21 at 11:33
-
@Vaish please edit your question to describe the new/alternate specifications, or open a new question for the new issue. – L. Scott Johnson Aug 31 '21 at 12:10
-