Date Column

Adarian Searcy

Hello,

I have created date columns with (Restrict to dates only) off. I am returning the correct dates in the correct columns. However, August is returning #NO MATCH in blank columns, I would like for these columns to remain blank until a date is added. Formulas for both columns are listed below.

July Formula

=IFERROR(INDEX({July Completion of OSV+ Attestation Form R Range 1}, MATCH([Email Address]@row, {July Completion of OSV+ Attestation Form R Range 2}, 0)), "")

August Formula

=IFERROR(INDEX({August Completion of OSV+ Attestation For. Range 1}, MATCH([Email Address]@row, {August Completion of OSV+ Attestation For. Range 2}, 0))"")

Any assistance is appreciated.

heyjay

Missing comma,

heyjay

Missing comma,

Adarian Searcy

Great catch, it works now. Thank you!