| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
couting consequetive months
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
couting consequetive months
=DATEDIF(A1,B1,"m")
this will give you the difference between the 2 dates in whole months. -- John C "Tom" wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
couting consequetive 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. "Tom" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
couting consequetive months
"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 "John C" wrote: =DATEDIF(A1,B1,"m") this will give you the difference between the 2 dates in whole months. -- John C "Tom" wrote: 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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
couting consequetive months
Thanks for the feedback, don't forget to check the Yes button. :)
-- John C "Tom" wrote: "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 "John C" wrote: =DATEDIF(A1,B1,"m") this will give you the difference between the 2 dates in whole months. -- John C "Tom" wrote: 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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
couting consequetive months
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. "David McRitchie" wrote: 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. "Tom" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| couting dates as events per month | Excel Worksheet Functions | |||
| Couting the number of referrences that... | Excel Worksheet Functions | |||
| How to add consequetive numbers in column | Excel Discussion (Misc queries) | |||
| couting based on age from today | Excel Discussion (Misc queries) | |||
| couting transactions for same time | Excel Worksheet Functions | |||
Linear Mode
