Formula Help

Question

I'm attempting to write a formula where it looks for a date in "Date 1" and if there is a date, then do a calculation. If there is no date in "Date 1", then use "Date 2" and calculate.

I want the AdjustMonth to look in [I-INDOC Continuing Qual Date] first. If no date is found, then use the [I-INDOC Qualification Date].

------------------------------
Tony Miller
------------------------------

MarkShnierYou · Answer

I can't edit a screen shot so in future you will receive better answers if you copy and paste your formula, but you want something like this

IF(not IsNull([my date field 1]), [my date field 1], my formula goes here)

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community