How to display a message if no value is entered in a cell?
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.
Help Article Resources
Check out the Formula Handbook template!