Thread: Apply a formula based on whether a cell is blank or has a date
View Single Post
 
Old 09-16-2021, 10:16 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Maybe something like (on fly)
Code:
=NETWORKINGDAYS(N2, IF(X2="",TODAY(),X2))-1
Reply With Quote