How to display a message if no value is entered in a cell?

Glenn DeMedeiros

I have a sheet where there is a column called Actual Start and Actual Finish. I have the following formula providing the difference of "Hours of Effort" based on these two dates.

Formula: =NETWORKDAYS([Actual Start]35, [Actual Finish]35)

However, sometimes the Actual Finish column will not have a date, therefore how do I keep the original formula and enhance it where if no date is entered in the Actual Finish column, then a message can be displayed.

Thanks,

Glenn DeMedeiros

gdemedeiros@dph.sbcounty.gov

Andrée Starå

Hi Glenn,

Try something like this.

=IFERROR(NETWORKDAYS([Actual Start]@row; [Actual Finish]@row); "")

The same version but with the below changes for your and others convenience.

=IFERROR(NETWORKDAYS([Actual Start]@row, [Actual Finish]@row), "")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Glenn DeMedeiros

Thank you, Andrée Starå!

Worked as a charm...I appreciate your assistance and support...I hope you have a great week :)!

Sincerely,

Glenn DeMedeiros

Andrée Starå

Excellent!

Happy to help!

✅Remember! Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi Glenn,

Try something like this.

=IFERROR(NETWORKDAYS([Actual Start]@row; [Actual Finish]@row); "")

The same version but with the below changes for your and others convenience.

=IFERROR(NETWORKDAYS([Actual Start]@row, [Actual Finish]@row), "")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Glenn DeMedeiros

Thank you, Andrée Starå!

Worked as a charm...I appreciate your assistance and support...I hope you have a great week :)!

Sincerely,

Glenn DeMedeiros

Andrée Starå

Excellent!

Happy to help!

✅Remember! Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!