Match the following Excel functions related to date formats with their purpose: 1 MONTHO 7 V DATE() 4 V =TODAY() 5 v =WEEKDAY() 6 v =DATEVALUE() 3 v YEAR() 2 v =DAY() 1: Returns the month, a number from 1 (January) to 12 (December) 2. Returns the day of the month, a number from 1 to 31 3. Returns the year of a date, an integer in the range 1900 - 9999 4. Returns the current date formatted as a date 5. Returns a number from 1 to 7 identifying the day of the week of a date 6. Converts a date in the form of text to a number that represents the date in Microsoft Excel date-time code 7. Returns the number that represents the date in Microsoft Excel date-time code