Question: INSTRUCTIONS 2 . 7 ) Use Today ( ) and / or Now ( ) to set the current Date and Time 2 . 8
INSTRUCTIONS Use Today andor Now to set the current Date and Time Use the appropriate functions to calculate the Year, Month, Day, Hour, Minute and Second from the dates calculated in # above for Cells CC Use EOMONTH and other nested functions to calculate the values in Cells CC Use the YEARFRAC and EOMONTH functions to determine through the year. Set a project due date of months from the current date for instance, if today is then the due date would be Using DATEDIF, NETWORKDAYS and any other appropriate functions, calculate cells FF using the appropriate functions. Account for the Holiday List below when calculating # of working days.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
