Thread: Blank Date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NotGood@All NotGood@All is offline
external usenet poster
 
Posts: 14
Default Blank Date

I have 2 date fields, B30 & C30 and a number field F30. I want to calculate
the Net Workdays between B30&C30 putting the answer in F30, but if C30 is
blank, I want F30 to be blank. I used this code in F30
=IF(C30="","",NETWORKDAYS(C30-B30)) but I cant get it to work. Would
someone please help me!
--
NotGood@All