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 less 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) | |||
I need to find out the YEAR, MONTH, DAY between two dates | Excel Discussion (Misc queries) | |||
How do I sort dates by month rather than by year? | Excel Discussion (Misc queries) | |||
How sort dates just by day/month and NOT year if all 3 given in ce | Excel Worksheet Functions | |||
how to calculate total months from month/year | Excel Discussion (Misc queries) |