Excel 2007 data list

  • Thread starter Thread starter Mike Johnson
  • Start date Start date
M

Mike Johnson

Hi,

I want to make Excel get the next weekday automatically. eg. I have tried to
make a list with days (M,T,W,T,F,S,S). But is there a way to get the next
day my just adding 1 and thereby getting the next letter from the list ?

Eg.
A1 | A2
M | 1

A3 | A3
| 2

It's in cell A3 I want to get the next weekday.

TIA

MJ
 
Hi Mike

Taking both of your messages as one.
I take it you want to colour cells, if the dates in column A are weekdays,
but not colour them if they are weekend days.

If you select your range in column A>Format>Conditional Formatting>use
dropdown to select Formula is>
=WEEKDAY($A1,2)<6 >Format>Fill>Choose colour>OK

weekday(date,2) gives a result of 1 for Monday ..... 5 for Friday, 6 for
Saturday and 7 for Sunday.
The formula will thus return True if the date is Monday through Friday.

If this is not what you want, then post back.
 
Sorry Mike

I hadn't noticed you said XL2007.
The formula is correct, but the method of setting the CF is slightly
different.

Select your range of cells in column A>Home tab>Conditional Formatting>New
rule>Use a formula to Determine which cells to format>enter the formula in
the white pane that appears>click Format>Fill>Colour
 
Back
Top