![]() If ((Yearnow Mod 4 = 0 And Calyear Mod 400 = 0) Or (Calyear Mod 4 = 0 And Calyear Mod 100 0)) Then ' based on a birthdate entered in cell A2 and insert the ' a Macro to calculate the age in years, months and days ![]() Here's an eleven year's old macro that could be used to do it (though I am sure that I could improve on it if I was to do the same thing now: Do read the document's introductory material. The above code is based on the item titled 'Interactively Calculate A Person’s Age'. Plus, the code is for an ordinary field - you don't use a formfield.įor information on how to do just about everything else you might want to do with dates in Word, check out my Microsoft Word Date Calculation Tutorial, at: ![]() ') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message.
0 Comments
Leave a Reply. |