make continuous list of days of week without Sunday

[pb.admin]

How can I make a continuous list of the days of the week without including
Sunday? I use Excel 2000. I need to make a "to-do" list for everyday,
except Sunday.

 

[Jacob Skaria]

Enter a date in A1

Enter the below formula in A2 and copy/drag down as required
=A1+IF(WEEKDAY(A1)=7,2,1)

If this post helps click Yes

 

[YESHWANT]

hi Jacob Skaria,

i think in A2 it should be
=IF(WEEKDAY(A1)=6,1,1+WEEKDAY(A1))

 

[Kassie]

Hi YESHWANT

Your formula will not give a weekday, nor will it give a date. Jacob's
formula, on the other hand, gives the correct date. If A1 is a Saturday's
date, A2 will give a Monday's date. Your's will result in an 8.
--
HTH

Kassie

Replace xxx with hotmail