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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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:31 AM.