Excel date time function formula

In actual work, there are many places where date and time are used. If it is handled manually every time, it will be very troublesome.

1. Get the current system date and time.

Method:

1. Select the target cell.

2. Shortcut keys: Ctrl;, Ctrl Shift;

2. YEAR: Calculate the year .

Method:

Enter the formula in the target cell: =YEAR(A3).

3. MONTH: Calculate the month.

Method:

Enter the formula in the target cell: =MONTH(A3).

4. DAY: Calculate the number .

Method:

Enter the formula in the target cell: =DAY(A3).

五、TEXT: Week (China).

Method:

Enter the formula in the target cell: =TEXT(A3,"aaaa").

Six, TEXT: Week (English) .

Method:

Enter the formula in the target cell: =TEXT(A3,"dddd").

7. LEN MONTH: Calculate quarter .

Method:

Enter the formula in the target cell: =LEN(2^MONTH(A3)).

8. WEENNUM: The calculated date is the week of this year.

Method:

Enter the formula in the target cell: =WEEKNUM(A3).

Nine, Day X.

Method:

Enter the formula in the target cell: =A3-"1-1" 1.

10. DAY EOMONTH: There are a few days in this month.

Method:

Enter the formula in the target cell: =DAY(EOMONTH(A3,0)).

For more Excel-related technical articles, please visit the Excel Tutorial column to learn!

The above is the detailed content of Excel date time function formula. For more information, please follow other related articles on the PHP Chinese website!