=TEXT(I21,"MMYY")
 

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

=TEXT(I21,"MMYY")
 

=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

=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

=TEXT(I21,"MMYY")
 

Will this work?

=IF(I21<"",TEXT(I21,"MMYY"),"Unscheduled")

HTH,
Elkar


"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

=TEXT(I21,"MMYY")
 

that makes all values return an "Unscheduled" value...I only want the "blank"
cells to read "unscheduled"

"Miguel Zapico" wrote:

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

=TEXT(I21,"MMYY")
 

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

=TEXT(I21,"MMYY")
 

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

=TEXT(I21,"MMYY")
 

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

=TEXT(I21,"MMYY")
 

What exactly is in I21?

Beege

"Beege" wrote in message
...
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

=TEXT(I21,"MMYY")
 

That did it...you the man. Thank you.

"Kevin Vaughn" wrote:

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

=TEXT(I21,"MMYY")
 

You're welcome. Thanks for the feedback.
--
Kevin Vaughn


"Thank you, Heath" wrote:

That did it...you the man. Thank you.

"Kevin Vaughn" wrote:

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