time and date can be converted in Excel. For example, a specified date corresponds to a week. As long as we master the conversion skills, we can easily solid the line.
1. Convert date to Chinese week.
function: Text.
function: converts numeric values into text according to the specified numeric format.
Syntax structure: =TEXT (numerical value, format code).
Purpose: converts the date "June 14, 2022" to its corresponding Chinese week.
Method:
Enter the formula in the target cell: =TEXT(B3,"aaaa").
2. Convert date to English week.
function: Text.
Purpose: converts the date "June 14, 2022" to its corresponding English week.
Method:
Enter the formula in the target cell: =TEXT(B4,"dddd").
3. Find the weekly times corresponding to the specified date.
function: Weeknum.
function: returns the week of the year.
Syntax structure: =Weeknum(value, calculation type).
Purpose: returns the corresponding weekly time of "June 14, 2022".
Method:
Enter the formula in the target cell: =WEEKNUM(B5,2).
Interpretation:
Code 2 represents the start date of each week calculated from Monday. Other code meanings can be selected and used according to the system's associative function.
4. Calculate the countdown.
function: Date.
function: returns the number representing the date in the date time code.
Syntax structure: =Date(year, month, day).
Purpose: calculates the number of days from the current date to New Year's Day.
Method:
Enter the formula in the target cell: =DATE(YEAR(B6)+1,1,1)-TODAY().
Interpretation:
Use Year function to get the year in the current date, +1 to get the year of the New Year's Day date; then subtract the current date, which is the number of days away from New Year's Day.
5. Convert the specified time to hours.
Method:
Enter the formula in the target cell: =B7*24.
6. Convert the specified time to minutes.
Method:
Enter the formula in the target cell: =B8*24*60.
7. Convert the specified time to seconds.
Method:
Enter the formula in the target cell: =B9*24*60*60.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-