This weekday function looked promising but the same trouble may exist as
before: the dates will always vary in any given cell. B2 may have any day
of the week.

When I finally got a working formula - at least, it returns a value - I get
Thursday instead of Saturday.

I modified this: =IF(A2<>"",A2+1,"")

to what would work, which happened to be this:
=IF(A2<>"",WEEKDAY(A2+1,3),"")

And in the cell that is formatted to show date in text format, it says
Thursday instead of Saturday.

Did I do something wrong?


"Peter T" <peter_t@discussions> wrote in message
news:eLX$sMuuFHA.2064@TK2MSFTNGP09.phx.gbl...
> Look at Excel's WEEKDAY function, eg
>
> =WEEKDAY(mydate,3)
>
> If it returns 0-4 it's a weekday. Lends itself nicely to conditional
> formatting.
>
> Regards,
> Peter T
>
>
> "StargateFanFromWork" <noSpam@NoJunkMail.com> wrote in message
> news:e#4oZqtuFHA.2504@tk2msftngp13.phx.gbl...
> > Hope the subject line isn't totally muddy <g>.
> >
> > I have a spreadsheet that is super. The only trouble is that weekends
> > aren't differentiated from weekdays in any way.
> >
> > Since the spreadsheet contains a macro for the user to select the
starting
> > date and then the rest of the spreadsheet is then populated for 3 weeks
> > following that date, Saturday and Sunday always fall on different cells
at
> > any given time. Also, affected cells may say "Saturday" or "Sunday" but
> > there is actually only a formula in any of them. The only exception is
> the
> > very first cell which is the initial one the macro dumps to. So the
first
> > might read "Friday" if I choose today's date in the prompt box, but all
> the
> > rest of the days of the weeks shown display the dates according to
> > appropriate variations of this formula:
> >
> > =IF(A2<>"",A2+1,"")
> >
> > In today's example, this actual formula above displays "Saturday". The
> cell
> > immediately below displays "Sep.17.2005". I'm hoping that since it's
the
> > same type formatting issue, hopefully resolving cell colouring for the
> text
> > "Saturday" issue will lead me to figure out how to do so for dates that
> fall
> > on weekends.
> >
> > Is there a way to do this cell colour change under these conditions?
> >
> > I'm in favour of conditional formatting, but couldn't figure out how to
do
> > so because of the fact above that no actual text is found where all the
> > Saturdays and Sundays are, only the formula. Tx.! :oD
> >
> >
>
>