Continuous days tally not including weekends

[johnbrownbaby]

Hello,

I am trying to get a continuous running tally of days that does not include weekends. I used a formula to check if the date is a weekend, if true, return 0, else, add 1:

=IF(WEEKDAY(L5,2)>5,0,L7+1)

I am able to get the weekend as 0. However, the tally reverts back to 1 after the weekend. Can you help me continue to tally the days even after a weekend?

Thanks.

 

[steve the fish]

If L5 is your first date and then you have sequential dates down column L then try this in M5:

=IF(WEEKDAY(L5,2)>5,0,MAX(M2:M4)+1)