Date and Time functions are normally classified together in Excel. Some of the common Date and Time functions are:
Date
Datevalue
Day
Days360
Edate
Eomonth
Hour
Minute
Month
Networkdays
Now
Second
Time
TimeValue
Today
Weekday
Weeknum
Workday
Year
Yearfrac
The NOW function puts in the current date and time into a cell. You enter it like this: =NOW()
a serial value to the date
numerical
Format / Cells / Date
date
ask me plz...
You do not. Excel does not record the change date of an individual cell.
there the different pages you have in excel
Formatting. There are many ways of formatting dates in Excel.
A date series is used to fill a series with dates. The date can be increased by either a day, a week, a month or a year each time. This is one of the Fill Series options Excel provides.
The Excel NOW function retrieves the current date and time from the system clock of the computer or device running Excel. When the function is called, it provides the exact date and time at that moment. This means that the value will update each time the worksheet recalculates or when it is reopened.
Double click on the Date column header.