What's Wrong with This?
=max(TODAY(),MIN(L2,V2))-min(TODAY(),MIN(L2,V2))*if(MIN(L2,V2)Today(),-1,1)
--
regards,
Tom Ogilvy
"D" wrote in message news:LxpAc.5144$tC5.596@fed1read02...
Nope- doesn't work. I have a value of 7/1/04 in L2, and V2 is blank. The
result is ########. I also need this to be able to calculate the days in
a
negative number if the earliest date between the 2 dates is already past
today's date... Got any ideas?
Thanks!
D
"Bob Phillips" wrote in message
...
=TODAY()-MIN(L2,V2)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"D" wrote in message news:z_oAc.5140$tC5.1091@fed1read02...
Hey guys-
Sorry for the multi-post, but didn't know which group this belongs
to...
I have 2 columns for dates. Sometimes only one of the two has an entry
in
it. Sometimes they both do. Although, they're NEVER both blank. I am
trying
to create a function that will compare the 2 dates (if there's even 2
there), and find out which one is the earliest of the two. If one date
is
missing from one column, it will just use the other date as the entry.
Once
it finds the earliest date between them, I want it to count how many
days
from the earliest date till today's date. I thought I did this right,
but,
the results are returning a #VALUE! answer. Can someone see what's
going
on
here and tell me how to make this work?
Thanks!
=IF(L2="", DAYS360(V2,TODAY())), IF(V2="", DAYS360(L2,TODAY())),
IF(L2<V2,
DAYS360(L2,TODAY())), IF(L2V2, DAYS360(V2,TODAY())), IF(L2=V2,
DAYS360(L2,TODAY()))
D
|