Microsoft Office Forums - View Single Post - Apply a formula based on whether a cell is blank or has a date

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

View Single Post

Old

09-16-2021, 02:59 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows 10

Windows 10 jeffreybrown uses Office 2016

jeffreybrown uses Office 2016

Office 2016

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown 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