| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to calculate number of month from 2008 in Excel?
I need to calculate the number of months from today to 2008 Dec 31, and
put that in an Excel cell with equal sign, and fraction of a month is divided by 31. How do I do that? PS: I am not looking for dedicated VBA script module. Thank you. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to calculate number of month from 2008 in Excel?
See answers in .misc
Frank wrote: I need to calculate the number of months from today to 2008 Dec 31, and put that in an Excel cell with equal sign, and fraction of a month is divided by 31. How do I do that? PS: I am not looking for dedicated VBA script module. Thank you. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to calculate number of month from 2008 in Excel?
Thank you.
"Andrew Taylor" wrote in message oups.com... See answers in .misc Frank wrote: I need to calculate the number of months from today to 2008 Dec 31, and put that in an Excel cell with equal sign, and fraction of a month is divided by 31. How do I do that? PS: I am not looking for dedicated VBA script module. Thank you. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to calculate number of month from 2008 in Excel?
Just a hint:
if you have =today() in A1 and 31/12/2008 in B1 then in C1 ="=" & (YEAR(B1)-YEAR(A1))*12+MONTH(B1)-MONTH(A1)& " Motnhs, " & DATEDIF(A1,B1,"md") & " Days" will give you =34 Months, 24 Days and =DATEDIF(A1,B1,"y") & " Year " & DATEDIF(A1,B1,"ym") & " Months " & DATEDIF(A1,B1,"md") & " Days" will give you 2 Years 10 Months 24 Days and ="=" &(YEAR(B1)-YEAR(A1))*12+MONTH(B1)-MONTH(A1)& " and " & DATEDIF(A1,B1,"md") & "/31" will give =34 and 24/31 Thanks Frank wrote: I need to calculate the number of months from today to 2008 Dec 31, and put that in an Excel cell with equal sign, and fraction of a month is divided by 31. How do I do that? PS: I am not looking for dedicated VBA script module. Thank you. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to calculate number of month from 2008 in Excel?
Thank you Soniya.
"Soniya" wrote in message oups.com... Just a hint: if you have =today() in A1 and 31/12/2008 in B1 then in C1 ="=" & (YEAR(B1)-YEAR(A1))*12+MONTH(B1)-MONTH(A1)& " Motnhs, " & DATEDIF(A1,B1,"md") & " Days" will give you =34 Months, 24 Days and =DATEDIF(A1,B1,"y") & " Year " & DATEDIF(A1,B1,"ym") & " Months " & DATEDIF(A1,B1,"md") & " Days" will give you 2 Years 10 Months 24 Days and ="=" &(YEAR(B1)-YEAR(A1))*12+MONTH(B1)-MONTH(A1)& " and " & DATEDIF(A1,B1,"md") & "/31" will give =34 and 24/31 Thanks Frank wrote: I need to calculate the number of months from today to 2008 Dec 31, and put that in an Excel cell with equal sign, and fraction of a month is divided by 31. How do I do that? PS: I am not looking for dedicated VBA script module. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you calculate the number of weeks on a month | Excel Discussion (Misc queries) | |||
| Calculate Number of Days in a Month | Excel Worksheet Functions | |||
| ??Calculate week number of a month | Excel Worksheet Functions | |||
| How do I calculate number of Mondays in a given month in Excel? | Excel Worksheet Functions | |||
| How to calculate number of month from 2008 in Excel? | Excel Discussion (Misc queries) | |||
![Frank[_25_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
