Help calculating dates within a forumula
On Wed, 15 Aug 2007 07:44:02 -0700, James A. Resnick
wrote:
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:
=IF(E3("10/31/2007"),("10/31/2007"), IF(E3<("10/31/2007"),E3-7))
or
=IF(E3(DATE(2007,10,31)),(DATE(2007,10,31)), IF(E3<(DATE(2007,10,31)),E3-7))
--ron
|