Forum Discussion
How do I add "if blank" to disregard
I have this formula =MAX(W2,Y2,AA2,AC2,AE2,AG2,AI2) to calculate the most current date in the following cells, I want to add that to leave the cell blank if there is no date in one of the cells so I ...
Try this formula:
=LET(
dates, TAKE(WRAPCOLS(W2:AI2, 2, 0), 1),
IF(COUNT(dates) < 1, "", MAX(dates))
)