View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
martyn martyn is offline
external usenet poster
 
Posts: 12
Default Date formual issue

Hi everyone

I have two colums with dates in and I want to subtract one from the other so
so I can get hte dumber of days between the two, this is the east part. The
problem I have is when one of the colums is blank I want to use todays date
so I can avoid #VALUE! being returned, I been reading a looking up posts here
for the best part of two hours and can not find the answer, can anyone help
me please?

Many thanks
Martyn