Date format

Copper Contributor

I need to have a list of days of week except Sunday and follow that in the next column by the corresponding day of week.......cannot figure out how to exclude Sundays from the weekdays....

3 Replies

@Shopkins64 

 

WEEKDAY function

This article describes the formula syntax and usage of the WEEKDAY  function in Microsoft Excel.

 

or a Examble with:

=WORKDAY(A2,B2)

add days excluding weekends

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)

 

@Shopkins64 ,

enter the first date e.g. in cell A1 and put the following formula in the rows below:

=A1+IF(WEEKDAY(A1;1)=7;2;1)

The formula checks, if the day in the cell above is a Saturday (weekday = 7). If yes, it adds 2 days, otherwise just one day.

In the next column you can place a reference to column a and format it with custom cell format "DDDD" to get the name of the weekday.

@Shopkins64 

Enter the start date in a cell, say in A2.

In the cell below (A3), enter the formula:

=WORKDAY.INTL(A2,1,11)

or, if you have a very old version of Excel:

=A2+1+(WEEKDAY(A2)=7)

Fill down from A3.

 

In the cell to the right of the start date (B2), enter the formula =A2 and format this cell with the custom format ddd for Mon, Tue etc., or dddd for Monday, Tuesday etc.

Fill down from B2.