Question

Use the WEEKDAY function in cell C8 to calculate the day of the week for the birthdate entered in cell C4.

Use the WEEKNUM function in cell C10 to calculate the week of the year for the birthdate entered in cell C4.

Use the YEAR function in cell C12 to calculate the year for the birthdate entered in cell C4.

Calculate the difference between the birthdate entered in cell C4 and the current date in cell C6. Insert this calculation in cell C14.

Calculate the number of hours since the birthdate. Insert your calculation in cell C15. (hint: convert the number of days to number of hours by multiplying the number of days in C14 by 24.)

calculate the number of minutes since the birthdate. Insert your calculation in cell C16.

Calculate the number of seconds since the birthdate. Insert your calculation in cell C17.

Answer 1

Note: The following formulas can work with any date formats.

The following steps are used to calculate the day of the week for the birthdate entered in cell c4:

Select the cell C8.

Enter the following formula.

=WEEKDAY(C4)

The WEEKDAY function returns a day of the week. It is a build-in function in Excel.

Screenshot:

result - Microsoft Excel File Home! Insert Page Layout Formulas Data Review View Add-ins Team ア 를ゴ| General ー EA Delete·· Format- Q Cells Paste Styles ←.0 .00 .00 →.0 Clipboard Font Alignment Tal Number г5a Editing SUM 2 Date and Time Functions Enter your birthdate> Today's Date Day of the week you were born: Week of the year you were born: The year you were born: You have been alive for about: 4 11-8-17 11-9-17 WEEKDAYIC4) 10 ชา 32 12 13 14 15 16 17 HI Sheet1Sheet2Sheet3 Edit 2017 31 days 744 hours 44640 minutes 2678400 seconds 囲ロ凹100%

The following steps are used to calculate the week of the year for the birthdate entered in cell C4:

Select the cell C10.

Enter the following formula:

=WEEKNUM(C4)

The WEEKNUM() function return the week number of the specific year.

Screenshot:

result - Microsoft Excel File Home! Insert Page Layout Formulas Data Review View Add-ins Team ア 를ゴ| General Delete. EA , Paste 0 .00 .00.0 Format2 Clipboard Font Alignment Tal Number г5a Cells Editing SUM WEEKNUM(CA 2 Date and Time Functions Enter your birthdate> Today's Date Day of the week you were born: Week of the year you were born: The year you were born: You have been alive for about: 4 11-8-17 11-9-17 6 10 =WEEKNUM(C4) ชา 12 13 14 15 16 17 2017 31 days 744 hours 44640 minutes 2678400 seconds Edit 囲ロ凹100%

The following steps are used to calculate the year in cell C12 for the birthdate entered in cell C4:

Select the cell C12.

Enter the following formula:

=YEAR(C4)

The YEAR() function is used to find the year. It return the year from the selected date.

Screenshot:

The following steps are used to find the difference between the birthdate entered in cell C4 and the current date in cell C14:

Select the cell C14.

Enter the following formula:

=C6-C4

This formula will return the difference between the two days.

Make sure the cell must be in General format.

Screenshot:

result - Microsoft Excel File Home! Insert Page Layout Formulas Data Review View Add-ins Team a ア Art Delete 2 EA Genera Paste ←.0 .00 .00.0 Format2 Clipboard Font 应| Alignment Number Cells Editing C14 2 Date and Time Functions Enter your birthdate> Today's Date Day of the week you were born: Week of the year you were born: The year you were born: You have been alive for about: 4 11-8-17 11-9-17 10 32 12 13 14 15 16 17 2017 31 days 744 hours 44640 minutes l. 2678400 seconds 14 トト1 | Sheet1( Sheet2 · Sheet3 ·ク Ready 囲1回凹10096(

The following steps are used to calculate the number of hours since the birthdate in cell C15:

Select the cell C15.

Enter the following formula:

=C14*24

The value in C14 contains the difference between two dates.

The formula =C14*24 returns the difference between two dates with hours.

Make sure the cell format must be in General.

Screenshot:

result Microsoft Excel File Home Insert Page Layoutormulas Data Review View Add-Ins Team23 ▼11 General ▼ Delete EA Paste Styles ーFormat-a- .00 →.0 Clipboard Font Alignment C14 24 | Number Cells Editing SUM 2 Date and Time Functions Enter your birthdate> Today's Date Day of the week you were born: Week of the year you were born: The year you were born: You have been alive for about: 4 11-8-17 11-9-17 10 32 12 13 14 15 16 17 2017 31 days -C14 24 hours 44640 minutes 2678400 seconds 14 トト1 | Sheet1( Sheet2, Sheet3 ·ク Edit 囲ロ凹100%

The following steps are used to calculate the number of minutes in cell C16:

Select the cell C16.

Enter the following formula:

=C15*60

The difference between the days from two days multiplying with 24 * 60 returns the minute’s value.

Make sure the cell format must be in General.

Screenshot:

result Microsoft Excel File Home! Insert Page Layout Formulas Data Review View Add-ins Team a ア General Delete EA Paste Styles ←.0 .00 .00 →.0 Format- Q Cells Clipboard Font Alignment Number Editing SUM C15 :ゆ 2 Date and Time Functions Enter your birthdate> Today's Date Day of the week you were born: Week of the year you were born: The year you were born: You have been alive for about: 4 11-8-17 11-9-17 10 32 12 13 14 15 16 17 2017 31 days 744 hours -C15 60 minutes 2678400 seconds I HI Sheet1. Sheet2 . Sheet3( * Edit |囲回凹 100%

The following steps are used to calculate the number of seconds since the birthdate in cell C17:

Select the C17.

Insert the following formula:

=C16*60

Screenshot:

result Microsoft Excel File Home! Insert Page Layout Formulas Data Review View Add-ins Team a ?coア InsertX Delete,, 쓺. Format- Q Cells General ー Paste ←.0 .00 .00 →.0 Clipboard Font Alignment | Number Editing SUM -C16 60 2 Date and Time Functions Enter your birthdate> Today's Date Day of the week you were born: Week of the year you were born: The year you were born: You have been alive for about: 4 11-8-17 11-9-17 6 10 32 12 13 14 15 16 17 2017 31 days 744 hours 44640 minutes -C16*60 econds Edit 囲ロ凹 100%