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, 02:59 PM

jeffreybrown jeffreybrown is offline

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

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

=IF(N(X2),NETWORKDAYS(N2,X2)-1,IF(X2="",TODAY()-N2,""))

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 06:56 AM.