Formula for calculating if something is overdue

Copper Contributor

Hi, I'm sure excel can do this I just can't figure out how.

 

I have a spreadsheet which has department names in the first column and dates across the top row. I have shaded the cell relevant to when each unit is scheduled to start a piece of work. How do I add a formula at the top of the worksheet to count which units are overdue to start work?

 

Thank you

1 Reply

Hi @Jessica Evans

 

There's no standard formula you can use to count shaded cells

 

The easiest solution would be to type a 1 in each cell you that corresponds to the start date

 

Then at the top of each date column do a sum of the column of 1s

 

Can you send a screenshot or attach a copy of the file if I'm not quite understanding what you're trying to do.

 

Thanks

 

Wyn