| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I calculate years between two dates
I'm trying to calculate age between A1 ( TODAYS' DATE) and B1 customer's
birthday, but all the formulas that I write in C1 ( that's where I want the age ) will give me for example 33.56, and if I take off the decimals then it will ROUND UP to 34 and thats not the real age. I basically want a formula that DOES NOT ROUND UP and gime JUST THE YEARS ( in this case 33). Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I calculate years between two dates
=DATEDIF(B1,A1,"y")
"FC" wrote: I'm trying to calculate age between A1 ( TODAYS' DATE) and B1 customer's birthday, but all the formulas that I write in C1 ( that's where I want the age ) will give me for example 33.56, and if I take off the decimals then it will ROUND UP to 34 and thats not the real age. I basically want a formula that DOES NOT ROUND UP and gime JUST THE YEARS ( in this case 33). Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I calculate years between two dates
To get fraction year
c1=datedif(b1,a1,"m")/12 format c1 as number with two decimals "FC" wrote: I'm trying to calculate age between A1 ( TODAYS' DATE) and B1 customer's birthday, but all the formulas that I write in C1 ( that's where I want the age ) will give me for example 33.56, and if I take off the decimals then it will ROUND UP to 34 and thats not the real age. I basically want a formula that DOES NOT ROUND UP and gime JUST THE YEARS ( in this case 33). Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add 100 years to a column of dates | New Users to Excel | |||
| NUMBER OF YEARS BETWEEN TWO DATES - HOW TO GET | Excel Worksheet Functions | |||
| Need formula to calculate days between dates or back date | Excel Discussion (Misc queries) | |||
| calculate number of days btw dates | Excel Worksheet Functions | |||
| calculate with dates before 1-1-1900 | Excel Worksheet Functions | |||
Linear Mode
