Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Example 1
Start date: 12/04/2004 End date: 12/04/2006 The formula should give the answer to 24 months Example 2 Start date: 12/04/2004 End date: 13/04/2006 The formula should give the answer to 25 months When I use function =(YEAR(A4)-YEAR(A3))*12+MONTH(A4)-MONTH(A3), it does not show 25 months for "Example 2" as it is still within the same month "April" Your kind support is greatly appreciated. TQ!//nginhong |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula to calculate age using birth date and current date | Excel Worksheet Functions | |||
Calculate a biweekly date | Excel Discussion (Misc queries) | |||
how to count weeks from date "X" then calculate | Excel Worksheet Functions | |||
calculate payment with first payment due date variable? | Excel Worksheet Functions | |||
calculate the number of days from date received | Excel Worksheet Functions |