Forum Discussion
Formula Help please
Hi
In my spreadsheet I have 2 columns that calculate the number of days (columns S and T) - they are both using column F to calculate the number of days (see screen shot).
How can I stop the ...
Nicki,
You have to turn off the formulas in the red area when the reference in column F is empty as below:
Replace the formula in cell S5 with this:
=IF(F5="","",DAYS360(F5,DATE(2018,7,31)+1))
And apply this workaround =IF(F5="","",ORIGINAL_FORMULA) to other columns the red area.
Thank you Haytham! Works a charm!