| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate month & year in between two dates
I have to calculate gratuity of an employee. for that reasone I have to
calculate total month & year from the date of joining to leaving date of employee. example - A B C 1 Date of Joining Date of Leaving Total Month & Year 2 11/02/2003 28/11/2006 in C2 I have to use a formula to calculate month & year, if calculate month is greater than 6 month then it round up 1 year else zero. Is there any formula about my quary. Thanks in advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate month & year in between two dates
Try this in c2. Ensure cell is formatted as general
=MROUND(DATEDIF(A2,B2,"m"),12)/12 Mike "Montu" wrote: I have to calculate gratuity of an employee. for that reasone I have to calculate total month & year from the date of joining to leaving date of employee. example - A B C 1 Date of Joining Date of Leaving Total Month & Year 2 11/02/2003 28/11/2006 in C2 I have to use a formula to calculate month & year, if calculate month is greater than 6 month then it round up 1 year else zero. Is there any formula about my quary. Thanks in advance |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate month & year in between two dates
=(DATEDIF(A2,B2,"ym")6)+DATEDIF(A2,B2,"y")
"Montu" wrote: I have to calculate gratuity of an employee. for that reasone I have to calculate total month & year from the date of joining to leaving date of employee. example - A B C 1 Date of Joining Date of Leaving Total Month & Year 2 11/02/2003 28/11/2006 in C2 I have to use a formula to calculate month & year, if calculate month is greater than 6 month then it round up 1 year else zero. Is there any formula about my quary. Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate year and month | Excel Discussion (Misc queries) | |||
| Calculate month & year in between two dates | Excel Worksheet Functions | |||
| Sorting dates by month instead of year | Excel Worksheet Functions | |||
| sort dates by month and day not year | Excel Worksheet Functions | |||
| how to calculate total months from month/year | Excel Discussion (Misc queries) | |||
Linear Mode
