DATE function (create countdown display board)
【Function】
The DATE function returns the serial number for a specific date.
【Syntax】
DATE ( year , month , day )
[Parameter]
year: Indicates that the value of the year parameter can contain one to four digits.
month: Represents a positive or negative integer, representing each month of the year from January to December (-month to December).
day: represents a positive or negative integer, representing the days from the 1st to the 31st of January.
【Example Application】
Create a countdown display board
In order to express the importance of a certain date, a countdown sign is usually created. You can use the DATE function with the TODAY function to create formulas.
Select cell C2 and enter the formula in the formula edit bar: = DATE (2023,1,21)- TODAY ()&＂(Day)＂Press the "Enter" key to get the countdown Number of days, as shown in Figure 4-5.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/DATE-han-shu-jian-li-dao-ji-shi-xian-shi-pai.html
支付宝扫一扫 
评论列表（196条）
测试