Help calculating dates within a forumula
James, I want the answer, too.
Waiting for Bob or someone else ...
"James A. Resnick" wrote:
WOW it worked...THANKS
So my question is, what does -- mean?? I just want to understand the
formula on a conceptual level.
--
James A. Resnick
"bau" wrote:
What Bob meant to write is
=IF(E3--"2007-10-31",--"2007-10-31", E3-7)
"Bob Phillips" wrote:
=IF(E3--"2007-10-31,--"2007-10-31", ,E3-7)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"James A. Resnick" wrote in message
...
I am trying to do a forumula that basicalls says that if a cell has a date
that is before 10/31/2007 than use the date in the cell minus 7 days. If
the
date in the cell is great than 10/31/2007 than simply use 10/31/2007. The
problem is that when I enter 1/31/2007 in the forumula it simply divides
the
numbers rather than reconizing it as a date. I have pasted the forumula
here
to see if anyone has a solution to the problem. What ends up happening is
the cell just lists 1/1/1900.
=IF(E3(10/31/2007),(10/31/2007), IF(E3(10/31/2007),E3-7))
Thanks,
James
Here is the forumula:
--
James A. Resnick
|