View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Redsphynx Redsphynx is offline
external usenet poster
 
Posts: 22
Default Counting Days with variables

Fantastic, works like a charm.

Thanks heaps

"Gary''s Student" wrote:

=IF(A1="","",IF(B1="",TODAY()-A1,B1-A1))
--
Gary''s Student - gsnu200820