excel统计连续工作天数
( )
Excel treats dates as integers. This means you can add and subtract them, which can be useful for telling you how many days there are until that next deadline or event of yours. In this article, we will use Excel’s DATE, YEAR, MONTH, DAY, and TODAY functions to show you how to calculate the number of days until your next birthday or any other annual event.
Excel将日期视为整数。 这意味着您可以添加和减去它们,这对告诉您下一个截止日期或事件有多少天很有用。 在本文中,我们将使用Excel的DATE,YEAR,MONTH,DAY和TODAY函数向您展示如何计算直到下一个生日或任何其他年度事件的天数。
Excel stores dates as integers. By default, Excel uses “1” to represent 01/01/1900 and each day after that is one greater. Type in 01/01/2000 and switch the format to “Number” and you’ll see “36526” appear. If you subtract 1 from 36526, you can see that there were 36525 days in the 20th century. Alternatively, you could enter a future date and subtract the result of the TODAY function to see how many days away that date is from today.
Excel将日期存储为整数。 默认情况下,Excel使用“ 1”代表01/01/1900,此后的每一天都大于一。 输入01/01/2000并将格式切换为“数字”,您将看到“ 36526”出现。 如果从36526减去1,则可以看到20世纪有36525天。 或者,您可以输入将来的日期,并减去TODAY函数的结果,以查看该日期距离今天还有多少天。
日期相关功能的快速摘要 (A Quick Summary of Date-Related Functions)
Before we dive into some examples, we need to go over several simple date-related functions, including Excel’s TODAY, DATE, YEAR, MONTH, and DAY functions.
在深入研究示例之前,我们需要遍历几个简单的与