Thread: formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chedd via OfficeKB.com
 
Posts: n/a
Default formula

I am adding two cells togetgher that contains dates to find the number of
actual days between them. The formula i am using is =I21-H21+1 quiet simple,
but on the empty cells i have default fig of 1 showing. Is there any way i
can remove this for a zero fig.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200605/1