Excel formula to output date excluding weekends

问题:

I need an Excel formula that starts with 1/1/2016 and can output the date in dd/mm/yyyy format for the rest of the year excluding weekends.

I did have this: =WORKDAY.INTL(1/1/2016,365,2) but it only outputs 511 which is 25/05/1901 and that is irrelevant for me.

回答1:

I think the problem lies in the fact that you use 1/1/2016 in the formula directly, and it is interpreted as a number instead of a date.

The following setup worked for me:

A1 =1/1/2016     B1 =WORKDAY.INTL(A$1, 1, 1)
                 B2 =WORKDAY.INTL(A$1, 2, 1)
                 B3 =WORKDAY.INTL(A$1, 3, 1)

(Also note that the last parameter, which is 2 in your case, makes Excel assume weekends fall on Sunday and Monday).