Help calculating dates within a forumula

Giganews Newsgroups
Subject: Help calculating dates within a forumula
Posted by:  James A. Resnick
Date: Wed, 15 Aug 2007

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

Replies