Hello,

I'm trying to create a formula that will allow me to check the
intervals in between dates. For instance I have
A1:1000 = Jan
B1:1000 = Feb
.....
L1:1000 = Dec

Contained in *most*of these cells I have data

Is it possible for me to count the number of days/months in between
each period. Say I have data in Dec, Nov, Oct but not in Sep, Aug, but
again in July, June, etc.....

Is this to be done with a countif statement?
I have the following but it doesn't return what I'm looking for
=COUNTIF(O5,\"=\"&J5-30)-COUNTIF(O5,\"\"&J5)

Many many thanks


--
Max_power
------------------------------------------------------------------------
Max_power's Profile: http://www.excelforum.com/member.php...o&userid=32255
View this thread: http://www.excelforum.com/showthread...hreadid=535551