Having trouble with dates

P

PerpetualJunior

I have worksheet with two date columns.... One a lower date, one a
higher date.
I need to work out the number of times a 1st of the month has occurred
in the time between the two dates.

Thanks for your help.

P.s if the description doesn’t make sense let me know, I’ll try to
describe it better.
 
J

JE McGimpsey

How many times has a first of the month appeared if the dates are

1 Jan 2004 and 1 March 2004? 1?, 2? 3?
 
J

Jerry W. Lewis

=MONTH(dateHigh)-MONTH(dateLow)

if nonzero, then the dates span the first of a month.

Jerry
 
P

PerpetualJunior

Eureka!!! Got it…
=(MONTH(dateHigh)-MONTH(dateLow))+((YEARdateHigh)-YEAR(dateLow))*12)


(Jerry. Thanks, you provided the inspiration
 
Top