| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Result in days and/or months
I would like to calculate two dates and get the result in days and/or
months. Can someone advise the syntax to get it. Thanks, Scott |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Result in days and/or months
On Nov 14, 3:02 pm, "Scott" wrote:
I would like to calculate two dates and get the result in days and/or months. Can someone advise the syntax to get it. Thanks, Scott Hi Scott Let's say A1 is your first date '1.Nov 2007 A2 is your second date '14.Nov 2007 you want to have the number of days in B1: =A2-A1 Format the cell as general, it returns 13 you want to have the number of months in B2: =month(A2-A1) + (year(A2-A1)-1900)*12 you want to have the numbers of days, without months =day(A2-A1) hth Carlo |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Result in days and/or months
For number of months you may find =DATEDIF(A1,A2,"m") easier than Carlo's
formula. -- David Biddulph "carlo" wrote in message ups.com... On Nov 14, 3:02 pm, "Scott" wrote: I would like to calculate two dates and get the result in days and/or months. Can someone advise the syntax to get it. Thanks, Scott Hi Scott Let's say A1 is your first date '1.Nov 2007 A2 is your second date '14.Nov 2007 you want to have the number of days in B1: =A2-A1 Format the cell as general, it returns 13 you want to have the number of months in B2: =month(A2-A1) + (year(A2-A1)-1900)*12 you want to have the numbers of days, without months =day(A2-A1) hth Carlo |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Result in days and/or months
On Nov 14, 3:02 pm, "Scott" wrote:
I would like to calculate two dates and get the result in days and/or months. Can someone advise the syntax to get it. Thanks, Scott Let's say A1 is your first date '1.Nov 2007 A2 is your second date '14.Nov 2007 you want to have the number of days in B1: =A2-A1 Format the cell as general, it returns 13 you want to have the number of months in B2: =month(A2-A1) + (year(A2-A1)-1900)*12 you want to have the numbers of days, without months =day(A2-A1) hth Carlo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i convert a number of days to years, months & days? | Excel Discussion (Misc queries) | |||
| i have two days and i want the difference in days, months, year | Excel Worksheet Functions | |||
| Add # of months and get result last day of # months. | Excel Discussion (Misc queries) | |||
| convert Days to Years, Months, Days | Excel Discussion (Misc queries) | |||
| not all months have 31 days | Charts and Charting in Excel | |||
Linear Mode
