While the cumulative number of days between two dates can be very useful, sometimes we would like to convert the number of days into a fraction of a year. The function to do that is YEARFRAC. It asks for a start date, end date, and a basis. For this problem use a basis of $1.$ More help with YEARFRAC can be found at this link.

For example, you would expect the fraction of a year between January $1$st and February $1$st to be approximately $1/12$st of a year $($one month$),$ or about $0\mathrm{.}8333(8\mathrm{.}33\%)$ of the entire year. In fact, it is $8\mathrm{.}49\%$; $=$YEARFRAC$(1/1/2019,2/1/2019,1).$ Note: To have the result show as a percentage, you may need to format the cell as a percent.

In cell I$4,$ find the faction of the year represented between the date in E$6$ and the beginning of the year $($to $1$ decimal$).$ Enter the percentage below without the $\%$ sign.

I$4$: fill in the blank $14$

$\%$

In cell I$5,$ find the fraction of the year represented between the date in E$6$ and the beginning of the month $($to $1$ decimal$).$ Enter the percentage below without the $\%$ sign.

I$5$: fill in the blank $15$

$\%$

While we have been learning about dates up to this point, nothing has shown us what day of the week a given date represents. Luckily, Excel has the WEEKDAY function to help find the name of the day. More help with WEEKDAY can be found at this link.

WEEKDAY requires a date and a return type which will almost always be $1.$ So $=$WEEKDAY$($date$,1).$ The function returns a number such as $1$ for Sunday, $2$ for Monday, etc. but not the actual day name. To obtain the day name, you will need to use the WEEKDAY function inside the TEXT function.

In cell I$7,$ use the function $=$TEXT$($WEEKDAY$($date$,1),"$dddd$")$ replacing date with E$6.$ What this does is find the weekday number and then uses the TEXT function to convert it to day of week name, which is what $"$dddd$"$ represents. The $"$dddd$"$ is a formatting instruction to the TEXT function. Enter the day of the week from I$7$ below $($capitalize the first letter$).$

I$7$: fill in the blank $16$

For the name of the month in cell I$10,$ perform a similar process as you did for the day of the week, but instead of $"$dddd$"$ use $"$mmmm$"$ which as you might guess, tells the text function to format as month. In this case you do not need WEEKDAY, just $=$TEXT$($date$,"$mmmm$").$ Enter the month name from I$10$ below $($capitalize the first letter$).$

I$10$: fill in the blank $17$

For various reasons, it is often helpful to know the number of actual workdays over a given period. Excel has the NETWORKDAYS function to calculate workdays. The function just takes a beginning date and an end date. For this question, use the beginning of the month and end of month in column E and place the result in I$12.$ How many workdays are in the current month? Ignore any holidays and leave the "Holidays" argument blank