make continuous list of days of week without Sunday
 

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.

make continuous list of days of week without Sunday
 

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
---------------
Jacob Skaria


"pb.admin" wrote:

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.