| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number of Months Between Two Dates Entered
Hello. I have a spreadsheet that has two cells -- Cell One is always today's
date using formula =Today(). The second cell is a date in the past. How can I calculate the number of months that have passed (rounded up) from the past date until today's date? I am hoping to see a number like "7" or "9" and not days. Thanks for your help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number of Months Between Two Dates Entered
Use DATEDIF function..
A1 = Start Date B1 = End Date =DATEDIF(A1,B1,"m") If this post helps click Yes --------------- Jacob Skaria "Rob" wrote: Hello. I have a spreadsheet that has two cells -- Cell One is always today's date using formula =Today(). The second cell is a date in the past. How can I calculate the number of months that have passed (rounded up) from the past date until today's date? I am hoping to see a number like "7" or "9" and not days. Thanks for your help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number of Months Between Two Dates Entered
Hello,
Thank you for the reply. I can't seem to get the formula to work correctly. Today's Date is 4/20/09 Start Date is 11/01/08 I was hoping to get the answer of 6 (for 6 months with April being rounded up). Any ideas? Thanks again for your help! Best Regards, Rob "Rob" wrote: Hello. I have a spreadsheet that has two cells -- Cell One is always today's date using formula =Today(). The second cell is a date in the past. How can I calculate the number of months that have passed (rounded up) from the past date until today's date? I am hoping to see a number like "7" or "9" and not days. Thanks for your help! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number of Months Between Two Dates Entered
=DATEDIF(A1,TODAY(),"m")+(DATEDIF(A1,TODAY(),"md") 0)
-- David Biddulph "Rob" wrote in message ... Hello. I have a spreadsheet that has two cells -- Cell One is always today's date using formula =Today(). The second cell is a date in the past. How can I calculate the number of months that have passed (rounded up) from the past date until today's date? I am hoping to see a number like "7" or "9" and not days. Thanks for your help! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number of Months Between Two Dates Entered
A1 = 11/1/2008
B1 = 4/20/2009 =DATEDIF(A1,B1,"M") will return 5 If this post helps click Yes --------------- Jacob Skaria "Rob" wrote: Hello, Thank you for the reply. I can't seem to get the formula to work correctly. Today's Date is 4/20/09 Start Date is 11/01/08 I was hoping to get the answer of 6 (for 6 months with April being rounded up). Any ideas? Thanks again for your help! Best Regards, Rob "Rob" wrote: Hello. I have a spreadsheet that has two cells -- Cell One is always today's date using formula =Today(). The second cell is a date in the past. How can I calculate the number of months that have passed (rounded up) from the past date until today's date? I am hoping to see a number like "7" or "9" and not days. Thanks for your help! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number of Months Between Two Dates Entered
=DATEDIF(A1,TODAY(),"M")
If this post helps click Yes --------------- Jacob Skaria "Rob" wrote: Hello, Thank you for the reply. I can't seem to get the formula to work correctly. Today's Date is 4/20/09 Start Date is 11/01/08 I was hoping to get the answer of 6 (for 6 months with April being rounded up). Any ideas? Thanks again for your help! Best Regards, Rob "Rob" wrote: Hello. I have a spreadsheet that has two cells -- Cell One is always today's date using formula =Today(). The second cell is a date in the past. How can I calculate the number of months that have passed (rounded up) from the past date until today's date? I am hoping to see a number like "7" or "9" and not days. Thanks for your help! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number of Months Between Two Dates Entered
Thank you. For some reason I am getting an anser of 1312. It seems like
excel is treating 11/1/2008 as if it is 11/1/1900...so it is telling me we have 1312 months in between the two. Any idea? "Rob" wrote: Hello. I have a spreadsheet that has two cells -- Cell One is always today's date using formula =Today(). The second cell is a date in the past. How can I calculate the number of months that have passed (rounded up) from the past date until today's date? I am hoping to see a number like "7" or "9" and not days. Thanks for your help! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number of Months Between Two Dates Entered
Jacob,
Thank you so much for the reply. For some reason I am getting a number of 1311. Oddly, this is the number of months between 11/1/1900 and today. My date range clearly reads 11/1/2008, my computer is XP and my excel is excel 2008. Do you have any ideas why my dates would be defaulting to 1900? Thanks again for your reply. "Jacob Skaria" wrote: A1 = 11/1/2008 B1 = 4/20/2009 =DATEDIF(A1,B1,"M") will return 5 If this post helps click Yes --------------- Jacob Skaria "Rob" wrote: Hello, Thank you for the reply. I can't seem to get the formula to work correctly. Today's Date is 4/20/09 Start Date is 11/01/08 I was hoping to get the answer of 6 (for 6 months with April being rounded up). Any ideas? Thanks again for your help! Best Regards, Rob "Rob" wrote: Hello. I have a spreadsheet that has two cells -- Cell One is always today's date using formula =Today(). The second cell is a date in the past. How can I calculate the number of months that have passed (rounded up) from the past date until today's date? I am hoping to see a number like "7" or "9" and not days. Thanks for your help! |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number of Months Between Two Dates Entered
Did you try formatting the cell to the date format..
-- If this post helps click Yes --------------- Jacob Skaria "Rob" wrote: Jacob, Thank you so much for the reply. For some reason I am getting a number of 1311. Oddly, this is the number of months between 11/1/1900 and today. My date range clearly reads 11/1/2008, my computer is XP and my excel is excel 2008. Do you have any ideas why my dates would be defaulting to 1900? Thanks again for your reply. "Jacob Skaria" wrote: A1 = 11/1/2008 B1 = 4/20/2009 =DATEDIF(A1,B1,"M") will return 5 If this post helps click Yes --------------- Jacob Skaria "Rob" wrote: Hello, Thank you for the reply. I can't seem to get the formula to work correctly. Today's Date is 4/20/09 Start Date is 11/01/08 I was hoping to get the answer of 6 (for 6 months with April being rounded up). Any ideas? Thanks again for your help! Best Regards, Rob "Rob" wrote: Hello. I have a spreadsheet that has two cells -- Cell One is always today's date using formula =Today(). The second cell is a date in the past. How can I calculate the number of months that have passed (rounded up) from the past date until today's date? I am hoping to see a number like "7" or "9" and not days. Thanks for your help! |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number of Months Between Two Dates Entered
The OP asked for rounded UP.
-- David Biddulph "Jacob Skaria" wrote in message ... =DATEDIF(A1,TODAY(),"M") If this post helps click Yes --------------- Jacob Skaria "Rob" wrote: Hello, Thank you for the reply. I can't seem to get the formula to work correctly. Today's Date is 4/20/09 Start Date is 11/01/08 I was hoping to get the answer of 6 (for 6 months with April being rounded up). Any ideas? Thanks again for your help! Best Regards, Rob "Rob" wrote: Hello. I have a spreadsheet that has two cells -- Cell One is always today's date using formula =Today(). The second cell is a date in the past. How can I calculate the number of months that have passed (rounded up) from the past date until today's date? I am hoping to see a number like "7" or "9" and not days. Thanks for your help! |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number of Months Between Two Dates Entered
The OP asked for rounded UP.
-- David Biddulph "Jacob Skaria" wrote in message ... A1 = 11/1/2008 B1 = 4/20/2009 =DATEDIF(A1,B1,"M") will return 5 If this post helps click Yes --------------- Jacob Skaria "Rob" wrote: Hello, Thank you for the reply. I can't seem to get the formula to work correctly. Today's Date is 4/20/09 Start Date is 11/01/08 I was hoping to get the answer of 6 (for 6 months with April being rounded up). Any ideas? Thanks again for your help! Best Regards, Rob "Rob" wrote: Hello. I have a spreadsheet that has two cells -- Cell One is always today's date using formula =Today(). The second cell is a date in the past. How can I calculate the number of months that have passed (rounded up) from the past date until today's date? I am hoping to see a number like "7" or "9" and not days. Thanks for your help! |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number of Months Between Two Dates Entered
HOw are you entering the date?
"Rob" wrote: Thank you. For some reason I am getting an anser of 1312. It seems like excel is treating 11/1/2008 as if it is 11/1/1900...so it is telling me we have 1312 months in between the two. Any idea? "Rob" wrote: Hello. I have a spreadsheet that has two cells -- Cell One is always today's date using formula =Today(). The second cell is a date in the past. How can I calculate the number of months that have passed (rounded up) from the past date until today's date? I am hoping to see a number like "7" or "9" and not days. Thanks for your help! |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number of Months Between Two Dates Entered
I don't think we know much about Excel 2008. That is presumably a Mac
version? If you format A1 temporarily as General, what number do you see? Should be 39753 if using 1900 date system. Macs normally default to the 1904 system, but your results imply the 1900 system. I assume that if you are struggling with Jacob's formula, you haven't tried my version which rounds *up* as you requested? -- David Biddulph "Rob" wrote in message ... Jacob, Thank you so much for the reply. For some reason I am getting a number of 1311. Oddly, this is the number of months between 11/1/1900 and today. My date range clearly reads 11/1/2008, my computer is XP and my excel is excel 2008. Do you have any ideas why my dates would be defaulting to 1900? Thanks again for your reply. "Jacob Skaria" wrote: A1 = 11/1/2008 B1 = 4/20/2009 =DATEDIF(A1,B1,"M") will return 5 If this post helps click Yes --------------- Jacob Skaria "Rob" wrote: Hello, Thank you for the reply. I can't seem to get the formula to work correctly. Today's Date is 4/20/09 Start Date is 11/01/08 I was hoping to get the answer of 6 (for 6 months with April being rounded up). Any ideas? Thanks again for your help! Best Regards, Rob "Rob" wrote: Hello. I have a spreadsheet that has two cells -- Cell One is always today's date using formula =Today(). The second cell is a date in the past. How can I calculate the number of months that have passed (rounded up) from the past date until today's date? I am hoping to see a number like "7" or "9" and not days. Thanks for your help! |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number of Months Between Two Dates Entered
=ROUNDUP((b1-a1)/30,0)
"Pimamedic" wrote: HOw are you entering the date? "Rob" wrote: Thank you. For some reason I am getting an anser of 1312. It seems like excel is treating 11/1/2008 as if it is 11/1/1900...so it is telling me we have 1312 months in between the two. Any idea? "Rob" wrote: Hello. I have a spreadsheet that has two cells -- Cell One is always today's date using formula =Today(). The second cell is a date in the past. How can I calculate the number of months that have passed (rounded up) from the past date until today's date? I am hoping to see a number like "7" or "9" and not days. Thanks for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting the number or months between two dates. | Excel Discussion (Misc queries) | |||
| Number of Months and Days between 2 dates? | Excel Worksheet Functions | |||
| Calculate number of months between dates | Excel Worksheet Functions | |||
| Calculate number of months between 2 dates | New Users to Excel | |||
| Number of months between 2 dates | New Users to Excel | |||
Linear Mode
