Excel公式输出日期(不包括周末) [英] Excel formula to output date excluding weekends

问题描述

我需要一个自2016年1月1日开始的Excel公式，并且可以输出dd/mm/yyyy格式的日期，用于其余年份(不包括周末).

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.

我确实有这个: = WORKDAY.INTL(1/1/2016,365,2)但它只输出511，即25/05/1901，对我来说无关紧要.

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/1/2016，并且将其解释为数字而不是日期.

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.

以下设置对我有用:

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).

这篇关于Excel公式输出日期(不包括周末)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！