I have an CV and would like to automatically update my age when opening. So, what formula should I insert in a MS Word field?
Something like:
{= {DATE} - {"01/01/1983"} }
I have an CV and would like to automatically update my age when opening. So, what formula should I insert in a MS Word field?
Something like:
{= {DATE} - {"01/01/1983"} }
This is one of the better sites for working with Word field codes - http://www.addbalance.com/usersguide/fields.htm - and there are examples there on how to create +/- dates.
Here's how you would calculate based of a birth month of January and birth year of 1983.
{IF{DATE\@"MM"} >= 01 { = {DATE\@"YYYY"} – 1983 \#"00"} { = {DATE\@"YYYY"} – 1984 \#"00"}}
Note that in the case of the month of January, this IF statement will always be true and give you =YEAR-1983. You can use another nested IF statement to check on the day to further get more accurate.