I need a bit more help with the data in these cases.

If E9 is a Friday date, it works fine, but if it is not, it becomes blank.
Can you describe what formulae you have where, and what the one that give
#VALUE should refer to, and produce as its result?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"clubbhouse" wrote in message
...
That one works until the date after the blank (Friday) after that it
returns
a #VALUE! error. Any other ideas? :-)

You are such great help. I would have never looked at these functions.

TIA,
Tammy



"Bob Phillips" wrote:

=IF(TEXT(F3,"dddd")="Friday","",LEFT(E9,FIND(" ",E9))&MID(E9,FIND("
",E9)+1,9)+1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"clubbhouse" wrote in message
...
Bob,
That would work if all of my weeks were 5 day weeks. Some of my weeks
only
have a couple of days in them due to holidays. Is there a function I
can
use
in this function statement? =IF(TEXT(F3,"dddd")="Friday","",E9) I
have
row
3 with the dates I will be schooling. The true statement currently
displays
a blank, the false statement is where I'm having troubles. My E9 cell
says
"Lesson 3". How can I increase it to say "Lesson 4" if the date is not
a
Friday? Then to piggy back it - the next date should be Monday - how
then
do
I increase the previous cell that isn't blank?

TIA,
Tammy

"Bob Phillips" wrote:

Maybe you could create a custom list (ToolsOptionsCustom Lists) with
a
nearly blank value, say a single dot, and fill using that.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"clubbhouse" wrote in message
...
I am trying to set up a homeschool schedule and need to have a blank
cell
but
contine the lessons. I used the fill handle to make the lesson
increase,
but
every Friday is a day for our co-op classes. How can I make this
happen
without manually going in and labeling the lessons?