Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Age with mont in decimal
Please can someone help me.
I need formula to get age and month I use the following, but get (example 53 0 instead of 53.0) =DATEDIF(H22,(L22),"y")&" "&DATEDIF(H22,(L22),"ym")&" " |
#2
|
|||
|
|||
Try this
=ROUND(DATEDIF(H22,(L22),"y")+(DATEDIF(H22,(L22)," ym")/12),2) -- HTH RP (remove nothere from the email address if mailing direct) "UPRAYUP" wrote in message ... Please can someone help me. I need formula to get age and month I use the following, but get (example 53 0 instead of 53.0) =DATEDIF(H22,(L22),"y")&" "&DATEDIF(H22,(L22),"ym")&" " |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert decimal degree (lattitude/longitude) into Degree, | Excel Discussion (Misc queries) | |||
Excel adds phantom decimal places: why? | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
decimal point override does not work | Excel Discussion (Misc queries) |