| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 320 | 1998-10-20 04:57:00 | Excel Functions | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 620 | 1998-10-20 04:57:00 | Could you please tell me a way to return the number of years from a given date Eg 29-02-1980 wourld return 18 Lotus has a function (@Datedif), but I cant't find one to do the same thing in Excel |
Guest (0) | ||
| 621 | 2003-05-02 03:52:00 | Use this formula =TRUNC((x-y)/364.25,0) where x is the latest date (d/m/yy) and y is the earlier date. (in separate cells of course) If you want you can replace x with now() which will be the current date. However it will change daily. (insignificant) If you want to record the age up to when say a person has died use this formula IF(c="",TRUNC((NOW()-y)/364.25,0),TRUNC((c-x)/364.25,0)) where c is the date of death (in another cell) Sorry this is long winded but I couldn't get an answer to that same question so I worked from ground up. |
Danny (136) | ||
| 622 | 2003-05-02 04:20:00 | Hello Danny, I see that you are bored, because you posted in a post, which is 6 years old! These will Not make the Mod’s happy. |
stu140103 (137) | ||
| 1 | |||||