View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dax Arroway Dax Arroway is offline
external usenet poster
 
Posts: 70
Default Day Counting - OPEN & CLOSED

I have three columns:
A=Start Date
B=End Date
C=Days

I'd like to count days if there is or is not an end date. So if the start
date was two weeks ago but there is no end date, I'd like the Days.column to
continue to increase as the days go by but end on the date entered into the
End.date column.

Seems easy but it's the easy things that elude me sometimes. Can someone
please help me with a formula for that?

Thanks in advance!!!
Dax