L
Legacy 98055
Guest
Hi all!
Column E = Date Opened
Column F = Date Closed
Column O = Difference in days
The above is fine...
Here's my problem...
Ex.
Cell E5 = 04/02/2002
Cell F5 = EMPTY or ""
I would like to display the days opened in
Cell O5
Meaning Today() - F5
The formula I am trying to use is giving me the #NAME?
=IF(AND(val(E5)<>0,val(F5)=0),NOW()-E5,F5-E5)
If E5 contains a date and F5 does not contain a date then formula needs to return the difference in days between Now - E5
Thanks for the help!
Tom
This message was edited by TsTom on 2002-04-06 11:07
This message was edited by TsTom on 2002-04-06 11:23
Column E = Date Opened
Column F = Date Closed
Column O = Difference in days
The above is fine...
Here's my problem...
Ex.
Cell E5 = 04/02/2002
Cell F5 = EMPTY or ""
I would like to display the days opened in
Cell O5
Meaning Today() - F5
The formula I am trying to use is giving me the #NAME?
=IF(AND(val(E5)<>0,val(F5)=0),NOW()-E5,F5-E5)
If E5 contains a date and F5 does not contain a date then formula needs to return the difference in days between Now - E5
Thanks for the help!
Tom
This message was edited by TsTom on 2002-04-06 11:07
This message was edited by TsTom on 2002-04-06 11:23