NOW & TODAY Functions
NOW Function
This function returns current (system) date and time
Syntax: NOW()
Example: =NOW()
Result: 31-08-2017 18:56 PM
TODAY Function
This function returns current (system) date.
Syntax: TODAY()
Example: =TODAY()
Result: 31-08-2017
TIME Function
This function returns the time from user supplied hour, minute and second.
Syntax: TIME(hour,minute,second)
Example: =TIME(12,24,44)
Result: 12:24 PM
Example: =TIME(8,20,00)
Result: 8:20 AM
DATE Function
This function returns the date from user supplied year, month and day.
Syntax: DATE(year,month,day)
Example: =DATE(2017,8,31)
Result: 31/08/2017
Example: =DATE(2010,1,11)
Result: 11/01/2010
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?
SUBSTITUTE Function
It is used to replace existing text with new text in a text string
Syntax: SUBSTITUTE(text,old_text,new_text,[instance_num])
Example: =SUBSTITUTE("Jitesh","J","H")
Result: Hitesh
REPLACE Function
It is used to replace a part of text string with new text.
Syntax: REPLACE(old_text,start_num,num_chars,new_text)
Example: =REPLACE("I love Banana",3,4,"hate")
Result: I hate Banana
MID Function
This function returns the characters from the middle of a text string, given a starting position and length.
Syntax: MID(text,start_num,num_chars)
Example: =MID("I Love India",3,4)
Result: Love
PROPER Function
Converts a supplied string into proper. ( Every first letter in every word will be capital rest of them will be small)
Syntax: PROPER(text)
Example: =PROPER("I love india")
Result: I Love India
