Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Outlook

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-21-2018, 01:01 PM
DanMichSr DanMichSr is offline Windows 8 Office 2013
Novice
 
Join Date: Jun 2015
Location: East Millinocket, Maine
Posts: 2
DanMichSr is on a distinguished road
Default

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
Reply With Quote
  #2  
Old 12-21-2018, 05:03 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,467
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

In that case, you might try:
ROUND(([Death Date] - [Birthday] )/ 365.25,2)
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 12-21-2018, 05:26 PM
DanMichSr DanMichSr is offline Windows 10 Office 2007
Novice
 
Join Date: Jun 2015
Location: East Millinocket, Maine
Posts: 2
DanMichSr is on a distinguished road
Default GREAT, Thanks

That is my answer........ Thank you very much
Reply With Quote
Reply

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


All times are GMT -7. The time now is 07:41 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft