Pulling a date based on if a field is blank
I have 2 columns of data, [Date1] and [Date2].
[Date2] is sometimes blank.
I want to create a new column of data that shows [Date2] if not blank, and [Date1] if blank.
Can someone help me create the correct formula for this? I guessed that I would need an IF formula with a ISBLANK within, but I'm having trouble with how to assign my results.
Help Article Resources
Check out the Formula Handbook template!