Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 04:19 PM.


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