couting consequetive months

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I'ce got a sheet with begin week (colomn A) and end week (colomn B) going
back a number of years. How do I add the cumalative months in colomn C?
 
=DATEDIF(A1,B1,"m")
this will give you the difference between the 2 dates in whole months.
 
Hi Tom,
Many spell checkers may skip the subject, but they all would check the message
body. Please use a spell checker before posting.

I think your question is rather ambiguous. Can you have dates
overlapping in rows, so can you produce multiple week counts
involving same date. If it is one week per row you might just
count the number of rows.

Does a start date always begin on Sunday and end on a Saturday
but may encompass more than one week.
 
"DATEDIF" excellent thanks, i changed it a little to:
=DATEDIF($A$1,B2,"m")
to get the differance from the row before making a cummulative value.
Thanks for lead.
Tom
 
Point taken, thanks on the spelling my bad, I'll also try to be more explicit
next time.
Otherwise the "DATEDIF" function put me on the right track to follow up on
and I was able to get it to work.
 
Back
Top