Our quarter runs September through November, I need to count the
number of Tuesdays, Wednesdays etc., remaining in the quarter. I've
come close by digging around in these forums but I'm stumped.

Remaining
Q1 F2008 F2008
Sunday 13 3
Monday 13 3
Tuesday 13 3
Wednesday 13 3
Thursday 13 3
Friday 13 3
Saturday 13 3


There are 13 of each weekday in Quarter 1.

I've cobbled together this formula to calculate the remaining days:

=P18-(INT((WEEKDAY($V$23-1,1)+$V$24-$V$23)/7))

P18 is the total number of Sundays in the quarter
$V$23 is the date: 1-sep-07 (start of the quarter)
$V$24 is the date: today()

I know that:

=WEEKDAY($V23,1)

will give me the Weekday number, but I don't know how to integrate a
count function into this to establish the remaining weekdays.

I've tried taking out the -1 but it didn't seem to affect anything.

If any one can point me in the right direction, I would appreciate it.

Andy