=TEXT(I21,"MMYY")
You may try something like:
=IF(I21<"",TEXT(I21,"MMYY"),"Unscheduled")
Hope this helps,
Miguel.
"Thank you, Heath" wrote:
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
|