Apply a formula based on whether a cell is blank or has a date

		Microsoft Office Forums > Microsoft Excel > Excel
Apply a formula based on whether a cell is blank or has a date

09-16-2021, 10:16 PM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 960

Maybe something like (on fly)

Code:

=NETWORKINGDAYS(N2, IF(X2="",TODAY(),X2))-1

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
if cell contains date, then month, else blank	Merlot	Excel	7	03-20-2025 08:16 AM
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
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 11:17 AM.