Hi all,

In column A I have date 1, in B I have date 2. In C I want to count the number of fridays between the two dates. I know how to count the number of days, but /7 won't work. Is there a way to count the number of fridays (or other days of the week) between two dates?

Additional Question:

In this Klaverjassers I have made a graphic over a time scale. But when there's no data yet (in the future) the graphic assumes the values are zero, so the lines run back to zero. No big deal, but it's plain ugly, so can I stop the lines from running back to zero and just let them 'stop' today?

Thabks in advance!

In column A I have date 1, in B I have date 2. In C I want to count the number of fridays between the two dates. I know how to count the number of days, but /7 won't work. Is there a way to count the number of fridays (or other days of the week) between two dates?

Additional Question:

In this Klaverjassers I have made a graphic over a time scale. But when there's no data yet (in the future) the graphic assumes the values are zero, so the lines run back to zero. No big deal, but it's plain ugly, so can I stop the lines from running back to zero and just let them 'stop' today?

Thabks in advance!

## Comment