In partnership with Experts Exchange.
There are several ways you can insert the date and time, including having it be constant or letting it update to the current date or time. Excel also has some efficient ways of formatting the date and time. In this episode, we will insert the date and time manually, with shortcuts and with functions, and we will apply formatting with the Format Cells dialog and with the Text function.