Thread: Days open Calculation
View Single Post
  #1   Report Post  
GRS6411 GRS6411 is offline
Junior Member
  
Posts: 2
Default Days open Calculation
I am using =NETWORKDAYS(A2,B2) for days open
How can i modify the above formula so it will pickup Todays's date if there is no date in B5.
Can anybody help ASAP with that.........
Attached Images
 
Reply With QuoteReply With Quote