Hello,

So I have a spreadsheet that tracks status of jobs.
My boss decided that he wants a column that appears/disappears based on if any jobs are late.
So for instance in my attached sample workbook. We see that two jobs are late, so my boss would ideally like the following:
  • Cells F2 and F3 should display the number of days they are late as seen in the sample workbook.
  • The rest of the cells in that column should be blank.
  • When no jobs are late the column should be hidden.
Unfortunately, I do not know of any way to hide/unhide a column via formula let alone how to have the column unhide and then run a formula.

Any help would be appreciated thank you!!!

Sample Workbook.xlsx