If you want to insert current date and time use the NOW function instead of TODAY. To insert the current date simply enter TODAY in the cell where you want it. To insert the time type the time and then click Home Number Format dropdown in the Number tab Time.
To insert the time type the time and then click Home Number Format dropdown in the Number tab Time.
If you want to insert current date and time use the NOW function instead of TODAY. Type the initial date in the first cell. There are many ways to get a date value for the first formula the date value is inserted in a cell the second formula uses the DATE function then added to the number 20. DATE 2015 5 20-5 - subtracts 5 days from May 20 2015.