Date format

%3CLINGO-SUB%20id%3D%22lingo-sub-2970151%22%20slang%3D%22en-US%22%3EDate%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2970151%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20have%20a%20list%20of%20days%20of%20week%20except%20Sunday%20and%20follow%20that%20in%20the%20next%20column%20by%20the%20corresponding%20day%20of%20week.......cannot%20figure%20out%20how%20to%20exclude%20Sundays%20from%20the%20weekdays....%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2970151%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2970198%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2970198%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1220214%22%20target%3D%22_blank%22%3E%40Shopkins64%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fweekday-function-60e44483-2ed1-439f-8bd0-e404c190949a%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EWEEKDAY%20function%3C%2FA%3E%3C%2FP%3E%3CP%3EThis%20article%20describes%20the%20formula%20syntax%20and%20usage%20of%20the%20%3CSTRONG%3EWEEKDAY%3C%2FSTRONG%3E%20%26nbsp%3Bfunction%20in%20Microsoft%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eor%20a%20Examble%20with%3A%3C%2FP%3E%3CP%3E%3CSPAN%3E%3DWORKDAY(A2%2CB2)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23FFFFFF%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F3445-excel-add-days-to-date-excluding-weekends-and-holidays.html%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%3Eadd%20days%20excluding%20weekends%3C%2FSPAN%3E%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20info.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolinoDE%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2970199%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2970199%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1220214%22%20target%3D%22_blank%22%3E%40Shopkins64%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3Eenter%20the%20first%20date%20e.g.%20in%20cell%20A1%20and%20put%20the%20following%20formula%20in%20the%20rows%20below%3A%3C%2FP%3E%3CP%3E%3DA1%2BIF(WEEKDAY(A1%3B1)%3D7%3B2%3B1)%3C%2FP%3E%3CP%3EThe%20formula%20checks%2C%20if%20the%20day%20in%20the%20cell%20above%20is%20a%20Saturday%20(weekday%20%3D%207).%20If%20yes%2C%20it%20adds%202%20days%2C%20otherwise%20just%20one%20day.%3C%2FP%3E%3CP%3EIn%20the%20next%20column%20you%20can%20place%20a%20reference%20to%20column%20a%20and%20format%20it%20with%20custom%20cell%20format%20%22DDDD%22%20to%20get%20the%20name%20of%20the%20weekday.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.