Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
On Wed, 19 Oct 2005 22:43:42 -0600, "Fred Smith" wrote:
You're better off using: =year(today())-year(a1) This will work next year, whereas a hard-coded 2005 will not. Correction to my previous -- I think horse's birthdays being on 1 Jan only applies to the northern hemisphere. I believe they are born on a different date in the southern hemisphere (? 1 Aug or 1 Jul) --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formulas not calculating correctly | Excel Discussion (Misc queries) | |||
Calculating Profit and Loss in one column | Excel Discussion (Misc queries) | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) |