Thank you,. that's perfect! I'd like to insert it throughout the worksheet
but weird numbers are appearing for the rows without start dates. Is there a
way of telling it to ingnore them? Also a correction, my colums are
A: Startdate
F: Enddate
G: DayCounter

"John C" wrote:

C2: =IF(B2="",TODAY()-A2,B2-A2)
or, so long as no end dates are in the future, you could eliminate the IF
statement:
C2: =MAX(MIN(B2,TODAY()))-A2
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Dax Arroway" wrote:

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