After looking at your reply to the answers that should have worked, I did a
little experimentation. Knowing that some people mask 0 values by setting
the option to not display 0's, I saw that that could cause a problem. Try
this formula:
=IF(A2=0,"",TEXT(A2,"mmyy"))
--
Kevin Vaughn


"Thank you, Heath" wrote:

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