Calculate how many times a day of the month will occur

R

rachel_130

Hello!

I am trying to calculate how many times a day of the month will occu
during a period of time. The periods of time change depending on whe
the person signs up.

For example: I need to know how many times the 20th of the mont
occurs between 4/1/04 and 7/19/04 or how many times the 4th of th
month occurs between 3/17/04 and 12/28/04 without having to go in an
count the occurances each time.

I am using Excel 2000.

Thank you!

Rache
 
H

Harlan Grove

rachel_130 > said:
For example: I need to know how many times the 20th of the month
occurs between 4/1/04 and 7/19/04 or how many times the 4th of the
month occurs between 3/17/04 and 12/28/04 without having to go in and
count the occurances each time.
Click to expand...
....

=SUMPRODUCT(--(DAY(ROW(INDIRECT(EarlierDate&":"&LaterDate)))=20))

unless you'd need to use dates after 5 June 2079 (date serial 65536 in 1900
date system).
 
Top