If there would be no numbers other than dates, the easy option is
=IF(ISNUMBER(A2),"package made","")
--
David Biddulph

"Eric D" wrote in message
...
Cool thanks David.

As I am not that excel advanced can you show me how this would look in the
IF statement?

There would never be an occasion that there would be other numbers in the
cell other than a date.
--
Eric


"David Biddulph" wrote:

The problem is that a date in Excel is merely a different way of
formatting
a number, so if you may have other numbers in that column you need to
find a
way of distinguishing your "dates" from other numbers. If the dates
don't
include times, then they will satify =MOD(A1,1)=0, but of course so will
any
integer numbers. If your dates are over a relatively limited range of
time,
then you can include that in your constraints. But if you have one cell
with 12 Jun 2008 (as a real date, rather than text), and another cell
with
39611, they will contain the same value. You might choose to use
=CELL("format",A1) to tell you which format is in use, which might be an
additional help.
--
David Biddulph

"Eric D" wrote in message
...
No it will not always be blank, but the only time a date appears i want
it
to
perform the function.
--
Eric


"JE McGimpsey" wrote:

If the cell in column D will be either blank or have a date:


E1: =IF(D1<"","package mode","")


In article ,
Eric D wrote:

Can anyone tell me if you can use an IF statement so that it
recognizes
a
non specific date.

for example: D1 has 6/11/08
I want to enter an IF statement so that if at any time column D has
a
date
then it will say "package made" in column E right beside the date.

Any suggestions?