Forum Discussion
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 wh...
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