Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-12-2021, 05:10 AM
teza2k06 teza2k06 is offline DATEDIF issue Windows 10 DATEDIF issue Office 2010 32bit
Advanced Beginner
DATEDIF issue
 
Join Date: Feb 2013
Posts: 37
teza2k06 is on a distinguished road
Default DATEDIF issue

Hi All,
I currently have a spreadsheet that calculates how old someone will be from their date of birth, as of 31/08/2022. However while the date of birth field is empty, it automatically defaults the age as of 31/08 field to 122.

Is there a way that while the date of birth field (E10) is empty, then age as of (F10) will show as 0 or just be blank?

My DATEDIF formula for the "Age as of" is in F10.

Many Thanks
Reply With Quote
  #2  
Old 11-12-2021, 06:40 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline DATEDIF issue Windows 7 64bit DATEDIF issue Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Try
Code:
 =DATEDIF(...)*(E10<>"")
which returns 0 if E10 is empty
Reply With Quote
  #3  
Old 11-14-2021, 03:35 AM
joeu2004 joeu2004 is offline DATEDIF issue Windows 7 32bit DATEDIF issue Office 2007
Advanced Beginner
 
Join Date: Aug 2016
Posts: 32
joeu2004 is on a distinguished road
Default

=IF(E10="", "", DATEDIF(E10,TODAY(),"y"))
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
PDF Conversion Issue - Background Tiled Image Size Issue dustpie Word 1 10-23-2016 07:33 PM
Is this a PowerPoint issue or a Mac issue? Brian_V PowerPoint 0 05-14-2015 09:19 AM
DATEDIF issue Using DateDif Function OTPM Project 5 03-17-2014 05:16 AM
DATEDIF issue Help with DATEDIF Formula caz46 Excel 7 01-12-2012 08:46 AM
New Issue jantoine Outlook 1 09-28-2010 06:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:34 PM.


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