Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-21-2018, 01:01 PM
DanMichSr DanMichSr is offline Decimal Places Windows 8 Decimal Places Office 2013
Novice
Decimal Places
 
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 Decimal Places Windows 7 64bit Decimal Places Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

In that case, you might try:
ROUND(([Death Date] - [Birthday] )/ 365.25,2)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-21-2018, 05:26 PM
DanMichSr DanMichSr is offline Decimal Places Windows 10 Decimal Places Office 2007
Novice
Decimal Places
 
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
Decimal Places 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:04 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft