2If you need to apply this formula to other cells please drag the AutoFill handle of the formula cell to these cells as you need. October 15 2015 has a serial number of 42292. Year RequiredThe value of the year argument can include one to four digits.
When you mix date functions with conditional formatting you can create spreadsheets that display date alerts automatically when a deadline is near or differentiate between types of days like weekends and weekdays.
Formula DAYS end_date start_date The function requires two arguments. Start - the starting date in the format that Excel can understand like 812020 or 1-Aug-2020. If you want to see the serial number in date format change to date. Excel interprets the year argument according to the date system your computer is using.