The function will continue to display the current date and time whenever the worksheet is opened. We can teach you how to replace those with IFERROR.
The DAYS function returns the number of days between two dates in a spreadsheet.
Click in a blank cell and type in =DAYS(C8, B8) (Replace C8 and B8 with your ending and beginning dates). Don't forget, Excel natively saves dates as serial numbers.
Here is a screenshot of the Function Arguments dialog box when working with the DAYS function.
Click in a blank cell and type in =TODAY()-B3 (Replace B3 with your start date). Open the Format Cells dialog box and change the date to a number.The TODAY function does not take any arguments so don’t put anything in between the parentheses.Example 1: In this example I am looking to return the current date in a cell.Click in a blank cell and type in =NETWORKDAYS(B8, C8) (Replace B8 and C8 with your beginning and ending dates).There is an optional third argument that allows you to exclude state, federal, or floating holidays.Example 3: In this example I would like to return the difference between todays date and a future date. Open the Format Cells dialog box and change the date to a number.Click in a blank cell and type = then click on the cell with the future date. Pro tip: Working on a whole column of data using Excel date functions? The NOW function displays the current date and time whenever you open your worksheet.There are 21 workdays minus July 4 for a total of 20 workdays.As you can see Excel date functions provide a quicker, more reliable ways to find the number of days between dates without having to count the days looking at a calendar!I don't know about you, but I always lose my place and have to start counting over again :-) For more useful functions, see our blog post on the top 5 Excel hacks.Some of financial and sales persons may require to insert new worksheet with current date every day for the statistics of daily work. Then press F5 key to run this code, and a new sheet with today’s date has been inserted after existing worksheets.