Thread: Excel Dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Excel Dates
if(b1<now(),networkdays(a1,b1),0)

would seem to be the easiest fix

Reply With QuoteReply With Quote