TEXT Function

TEXT Function

This function converts a value in to text using a user specified format.

Syntax: TEXT(value,format_text)

Example: =TEXT("26/8/2017","dd")
Result: 26






Example: =TEXT("26/8/2017","dddd")
Result: Saturday









Assignment:
1. Find month from "26/8/2017" by using text?
2. Find year from "26/8/2017" by using text?
3. Find month name from "26/8/2017" by using text?