Heath,

Then the cells must not be blank, really.

Try this

=IF(I21<30000,"unscheduled",TEXT(I21,"MMYY"))

(The 30000 is the number for a date around 1982, so if there's something
less than that, it will be unscheduled)

Beege


"Thank you, Heath" wrote in
message ...
This returns the cell "100" when its supposed to return the date.

Im tottally following you here but something is a wrong...if I21 is
"blank"
then put "unscheduled" if not put the month and year. it looks like this
should work but its returning "100"

"Beege" wrote:


=IF(I21="","unscheduled",TEXT(I21,"MMYY"))

Beege

"Thank you, Heath" wrote in
message ...
This formula looks at a cell and replaces the full date with jst the
month
and the year....but some cells are blank, in this case this formula
sends
back "100"

I need to add something to this formula that when the cell is
blank...instead of putting "100" as it does now, I need it to put
"Unscheduled"...

Like "If 100, then "Unsdchedule"

thanks a tonne.
Heath
Atlanta