6. In the dropdown menus below, select a month, a day and a year. Write a formula in cell F32 that outputs a date formatted as mm/dd/yyyy using the dropdown selections. Month October Day 2 Year 2010 Formatted Date

          6. In the dropdown menus below, select a month, a day and a year.
Write a formula in cell F32 that outputs a date formatted as mm/dd/yyyy using the dropdown selections.
Month
October
Day
2
Year
2010
Formatted Date

Added by Rafael P.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Supreeta N

07/28/2023

Step 1

Let's say these are cells B2, C2, and D2 respectively. Then, we can use the DATE function to create a date from these values. The DATE function in Excel takes three arguments: year, month, and day. However, since the month is given as a text string, we need to Show more…

Show all steps