| Formula Function | Use | Example |
| Today | Returns the todays date | =Today( ) |
| Weekday | Returns the serial number of days in week (1 for Sunday and 7 for Saturday) | = weekday(type current date) |
| Date | Returns the serial number of a particular date | =Date(Year, Month, Day) #(2023,09,21) |
| Month | Return the month of the specified data | =Month(Select the date) |
| year | Return the year of the specified data | =Year(Select the date) |
| Day | Return the Day of the specified data | =Day(Select the date) |
| Now | Return the current date and time | =Now( ) |
| Time | Return the serial number of particular time | =Time(Hour,Minute,Second)#(10,20,55) |
| Hour | Return the hour for a time | =Hour(select time) |
| Minute | Return the Minute for a time | = Minute (select time) |
| Second | Return the Second for a time | = Second (select time) |
| If | Specifies a logic test to perform | =if(Select logic, type value if true, type value if false) |
| SQRT | Returns the positive square root | =SQRT(Number) |
| Sum | To Add the arguments | =Sum(number1,number2, …..) |
| Mod | This function returns the remainder left over after a division operation. | =Mod(number, Divisor) #Mod(15,2)Return 1 answer |
| Average | Returns the average of arguments. | =Average(number1, number2, number3) |
| Left | Returns the left side of character from the selected text. | =Left(select Text, Num_chars) |
| Right | Returns the Right side of character from the selected text. | = Right(select Text, Num_chars) |
| Upper | Coverts character in uppercase | =Upper(select text) |
| Lower | Coverts character in lowercase. | =Lower(select text) |
| Replace | Replace charters with other characters. | =Replace(Select old text, Start_number, number of char, New text) |
| Mid | Returns a specific number of characters from a text string at the position you specify | =Mid(Select text, Start_num, Num_char) |
| Len | Returns the number of characters in a text string. | =Len(Select Text) |
| Proper | Capitalize the first letter in each word of a text. | =Proper(select text) |
| Concatenate | To join the two or more string. | =Concatenate(text1, text2) |