Nov 16 2021 05:32 AM
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....
Nov 16 2021 05:48 AM - edited Nov 16 2021 05:48 AM
This article describes the formula syntax and usage of the WEEKDAY function in Microsoft Excel.
or a Examble with:
=WORKDAY(A2,B2)
Hope I was able to help you with this info.
NikolinoDE
I know I don't know anything (Socrates)
Nov 16 2021 05:48 AM
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.
Nov 16 2021 05:52 AM
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.