Forum Discussion

Jessica Evans's avatar
Jessica Evans
Copper Contributor
Mar 15, 2017

Formula for calculating if something is overdue

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

Formulas & Functions
Need Help

1 Reply

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Mar 15, 2017

    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

Resources