Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-16-2021, 02:08 PM
NLJ NLJ is offline Apply a formula based on whether a cell is blank or has a date Windows 10 Apply a formula based on whether a cell is blank or has a date Office 2016
Novice
Apply a formula based on whether a cell is blank or has a date
 
Join Date: Jan 2020
Posts: 5
NLJ is on a distinguished road
Default Apply a formula based on whether a cell is blank or has a date

I'm trying to create a formula that will allow me to use the =NETWORKINGDAYS(start, end)-1 formula if a cell contains a data or the =TODAY()-cell if the cell is blank, but I can not figure it out. I'm trying the IF statement, but I know I've got errors. Here is what I've tried =IF(X2=" ",[NETWORKINGDAYS(N2,X2)-1],IF[X2=<>" ",[TODAY()-N2]).



Each formula works separately, but I can't figure out how to combine these to use the formula applicable to being either blank or not blank
.

Any advice, it's been quite a while since I've done something like this.
Thanks
Reply With Quote
  #2  
Old 09-16-2021, 02:59 PM
jeffreybrown jeffreybrown is offline Apply a formula based on whether a cell is blank or has a date Windows 10 Apply a formula based on whether a cell is blank or has a date Office 2016
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

An uploaded sample might help, but based on your description, try...

=IF(N(X2),NETWORKDAYS(N2,X2)-1,IF(X2="",TODAY()-N2,""))
Reply With Quote
  #3  
Old 09-16-2021, 10:16 PM
ArviLaanemets ArviLaanemets is offline Apply a formula based on whether a cell is blank or has a date Windows 8 Apply a formula based on whether a cell is blank or has a date Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Maybe something like (on fly)
Code:
=NETWORKINGDAYS(N2, IF(X2="",TODAY(),X2))-1
Reply With Quote
  #4  
Old 09-16-2021, 11:11 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Apply a formula based on whether a cell is blank or has a date Windows 7 64bit Apply a formula based on whether a cell is blank or has a date 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

Is NETWORKINGDAYS a new function in Excel? Can't seem to find any information??
Reply With Quote
  #5  
Old 09-17-2021, 06:02 AM
ArviLaanemets ArviLaanemets is offline Apply a formula based on whether a cell is blank or has a date Windows 8 Apply a formula based on whether a cell is blank or has a date Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Quote:
Originally Posted by Pecoflyer View Post
Is NETWORKINGDAYS a new function in Excel? Can't seem to find any information??
I think OP did mean NETWORKDAYS!
A good eye to catch this! I didn't think to check spelling!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for looking at 1 cell with a date and then comparing it to four date ranges LearningMom Excel 3 10-27-2017 12:44 PM
if cell contains date, then month, else blank Merlot Excel 4 10-03-2016 03:27 PM
Apply a formula based on whether a cell is blank or has a date Need help with using traffic lights in one cell based on date value in a different cell wmedjaxnjr Excel 1 04-09-2016 04:22 PM
calculate date if date entered in cell, do nothing if blank ConfuddledOne Excel 3 11-07-2014 09:37 AM
Change formula cell range based on cell value Scoth Excel 4 10-25-2012 07:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:30 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