#1) In cell D5, enter a formula to calculate the number of days for the first wo
ID: 3905623 • Letter: #
Question
#1) In cell D5, enter a formula to calculate the number of days for the first workshop. Add 1 to the results to include the total number of days, including the start and end dates. Copy the formula to the range D6:D9.#2) In cell I5, enter a formula to calculate th gross corporate revenue for the first workshop by multiplying the cost per attendee by the number of corporate attendees. Copy the formula to the range I6:I8.
Home Iniert Page Layout Formulas Dats Review Vew POF Inset Date Condtional Formatting format as Table . Calibri S . % , | 2 Cell Styles Fite Font DS June Training Workshops l of Attendees Gross Revenue Educatio Cost per n Corporat Educatio Corporat Educatio Start Date End Date # of Days Attendee Discount 0.1 5 Project Management 6 Adv. Project Management 6/7/2018 6/8/2018 7 Systems Analyst 8 Big Data Analytics 9 Project Management 6/25/2018 6/29/2018 6/4/2018 6/6/2018 999 0.1 2199 0.12 2199 0.15 1985 1010 6/11/2018 6/15/2018 6/18/2018 6/22/2018 14 12 10 12 14 15 16 17 18 19 23 26 29 31 32 35 37
Explanation / Answer
If you have any doutbs, please give me comment...
1)
DATEDIFF(C5, B5, "d")
DATEDIFF(C6, B6, "d")
DATEDIFF(C7, B7, "d")
DATEDIFF(C8, B8, "d")
DATEDIFF(C9, B9, "d")
2)
G5*E5
G6*E6
G7*E7
G8*E8
G9*E9
3)
H5*(E5-(E5*F5))
H6*(E6-(E6*F6))
H7*(E7-(E7*F7))
H8*(E8-(E8*F8))
H9*(E8-(E8*F8))
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.