#1
|
|||
|
|||
Outlook allows you to define your own fields and they can contain formula. So I used the standard field of BIRTHDAY and created a field for AGE etc. I have views set up for my Children and Grandchildren and wanted to have their age shown. For the age of the child I use the formula.....
IIf([Birthday]<>"None",DateDiff("yyyy",[Birthday],Date())-IIf(DateDiff("d", CDate(Month([Birthday]) & "/" & Day([Birthday]) & "/" & Year(Date())),Date())<0,1,0),"") That works well but would like it to show 2 decimal places and am working on trying to figure that out. For my past relatives I used their BIRTHDAY and created a simple formula as ([Death Date] - [Birthday] )/ 365.25 And come up with an answer of 56.223342211 or something like that. I would like to have it give me 56.2 or 56.22 |
#2
|
||||
|
||||
In that case, you might try:
ROUND(([Death Date] - [Birthday] )/ 365.25,2)
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
GREAT, Thanks
That is my answer........ Thank you very much
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to align decimal places in regular order? | Revathi | Word | 3 | 03-22-2018 07:13 AM |
Pulling 2 digits before a decimal point from adjoining cell then zeros after decimal | jadess916 | Excel | 1 | 06-26-2014 03:48 AM |
Forced extra decimal places | Metamag | Excel | 11 | 08-18-2012 03:10 AM |
Mail Merge, Number to 2 Decimal Places | Vampy99 | Mail Merge | 7 | 09-25-2011 05:41 AM |
My Places | lukewarmbeer | Office | 0 | 07-13-2010 02:33 PM |