![]() |
#2
|
||||
|
||||
![]()
One wouldn't expect to see the formula - it's in a field code in the cell concerned. To see it, unprotect the document and press Alt-F9. In the cell concerned, you should see something like:
{QUOTE{IF{=Birthdate \@ YYYYMMDD}= 0 "" "{Set Years{=INT(({DATE \@ YYYYMMDD}-{REF Birthdate \@ YYYYMMDD})/10000)}}{Years} Year{IF{Years}= 1 "" s} }"} It's a pretty simple formula, really.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel calculation help | Purge07 | Excel | 4 | 05-20-2016 07:46 PM |
Help with a sum calculation please. | ballst | Excel | 4 | 06-04-2015 11:40 AM |
Formula Calculation | medavidcook | Excel | 2 | 03-21-2015 03:47 AM |
Please help with age calculation!!! | Microsoft Idiot | Word | 4 | 10-29-2012 05:54 AM |