Return blank date if there is no data in the input cell

[mlalpers]

I am preparing a benefits tracking spreadsheet, and need to calculate the date COBRA would be effective (Column H) and terminate by default (Column I) based on the date an employee is terminated (Column F).

I think I have managed the proper basic formulas/functions in Cells H7 and I7, with the input cell being F7, but when Column F is empty, I get funky dates in Columns H and I.

I want Columns H and I to be blank if there's no information in Column F.

new insurance tracker.xlsx

[HansDouwe]

Try in H7: =IF(F7<>"";DATE(YEAR($F7);MONTH($F7)+1;1);"")

[mlalpers]

Unfortunately that formula returns an error and the Excel dialogue box doesn't tell where or what the error is.

[josephteh]

Formula could be shortened to: =IF(F7="","",EOMONTH(F7,0)+1).

[josephteh]

Replace the semi-colon to comma in HansDouwe's formula.