View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Terry Rogers[_2_] Terry Rogers[_2_] is offline
external usenet poster
 
Posts: 3
Default Counting days comparing 2 dates excluding empty cells

I've entered the formula =(L25-M3) in a target cell to count the length of
stay of patients on a hospital unit. L 25 contains the formula to enter the
current date,that is =today(). Each cell in column "M" is the hand entered
admission date. This formula works but I need it to ONLY do the calculation
if there is a value entered in column "M." What argument do I add to
suppress the calculation if "M" is blank? Currently it displays a bizzar
number.