make continuous list of days of week without Sunday

  • Thread starter Thread starter pb.admin
  • Start date Start date
P

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.
 
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
 
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
 
Back
Top