Count Consecutive Days from Today's Date

Hello All,

I have a spreadsheet that contains days that individuals has worked. I want to know how many consecutive days they have worked from today's date.

I have attached a spreadsheet that I think more clearly shows what I am trying to accomplish.

Hi,

you may try this formula.

COUNTIFS($B$2:$B$10,">7/4/2015",$A$2:$A$10,D2)

I'm struggling to understand your question in light of the uploaded file. The file indicates the answers are Peter 0, John 2 and Mary 0.

In the data I see Peter has worked 2 consecutive days, John has worked 2 sets of 2 consecutive days and Mary has worked 2 consecutive days.

I'm confused. Can you clarify?

Peter worked two consecutive days too but the formula didn't calculate it, only did for John who worked in the same dates (01/04/2015 and 02/04/2015)

Originally Posted by nflsales

@ZAHABI
OP is asked for "how many consecutive days they have worked from today's date"
Jhon Worked on 5th and 6th which are immediate dates before 7th but

Peter Worked on 1st and 2nd which are not immediate dates before 7th

Ahhhh! OK, Siva....thank you for clarifying that point. I didn't interpret as immediately before. I see my error.