Oct 06 2021 08:36 AM
Oct 06 2021 09:00 AM
@Lizzy2320 Perhaps something like this:
=IF(ISBLANK(B1),TODAY()-A1,B1-A1)
Using IFERROR makes no sense as there will not be an error. Just a TRUE or a FALSE. This formula will check if B is empty. If so, todays date, minus A, otherwise B minus A.
Oct 06 2021 09:22 AM
Oct 06 2021 11:17 AM
@Lizzy2320 Why not? See attached.
Oct 06 2021 12:12 PM
Oct 06 2021 12:33 PM
SolutionOct 06 2021 12:33 PM
Solution