Flag if thirty days has passed

[kimm199]

This is a bit of an odd one:

I have a spreadsheet which lists names in Column A and Dates in Row 1. Each day a person is present they receive a mark on that day (usually a 1). I want to put in column B an indicator of if a person has worked for over thirty consecutive days previous to today's date (and therefore needs to go on break.)

Maybe the formula can index today's date from Row 1, search for the first nonblank cell scanning backwards, then display the difference between todays date and the date corresponding to the first nonblank cell.

I'm trying to keep this particular workbook macro-free....

any help?

 

[VBACO]

I think I can help you but I would like to see a sample of your data. Can you post what your worksheet looks like please.