Text & Date functions

Reference for all 29 Text & Date functions in Kazi Sheets, with syntax and examples.

Clean, join and split text; work with dates and times. Kazi Sheets has 29 Text & Date functions. Type = in a cell, start typing a name, and Kazi suggests it.

#CONCAT

Joins multiple text strings or cell values into one.

Syntax

CONCAT(val1, val2, ...)

Example

=CONCAT(A2, " — ", E2)

#DATE

Creates a date from year, month, and day components.

Syntax

DATE(year, month, day)

Example

=DATE(2026, 10, 26)

#DATEDIF

Calculates the difference between two dates in "Y", "M", or "D".

Syntax

DATEDIF(start_date, end_date, unit)

Example

=DATEDIF(A2, B2, "M")

#DAY

Returns the day of the month (1 to 31).

Syntax

DAY(date)

Example

=DAY(TODAY())

#DAYS

Returns the number of days between two dates.

Syntax

DAYS(end_date, start_date)

Example

=DAYS("2026-12-31", TODAY())

#EDATE

Returns the date that is the indicated number of months before or after start date.

Syntax

EDATE(start_date, months)

Example

=EDATE(TODAY(), 6)

#EOMONTH

Returns the date for the last day of the month that is indicated months away.

Syntax

EOMONTH(start_date, months)

Example

=EOMONTH(TODAY(), 0)

#FIND

Finds the position of a substring (case-sensitive).

Syntax

FIND(find_text, within_text, [start_num])

Example

=FIND("-", A2)

#LEFT

Extracts a substring from the left side of a string.

Syntax

LEFT(text, [num_chars])

Example

=LEFT(A2, 4)

#LEN

Returns the character length of a text string.

Syntax

LEN(text)

Example

=LEN(A2)

#LOWER

Converts text to lowercase.

Syntax

LOWER(cell)

Example

=LOWER(A2)

#MID

Extracts a substring from the middle of a string.

Syntax

MID(text, start, length)

Example

=MID(A2, 2, 5)

#MONTH

Returns the month of a date (1 to 12).

Syntax

MONTH(date)

Example

=MONTH(TODAY())

#NETWORKDAYS

Returns the number of whole working days between start date and end date.

Syntax

NETWORKDAYS(start_date, end_date)

Example

=NETWORKDAYS(A2, B2)

#NOW

Returns current date and time string.

Syntax

NOW()

Example

=NOW()

#PROPER

Capitalizes the first letter of each word in a string.

Syntax

PROPER(cell)

Example

=PROPER(A2)

#REPLACE

Replaces characters within text starting at a specific position.

Syntax

REPLACE(text, start, num_chars, new_text)

Example

=REPLACE(A2, 1, 3, "UGX")

#REPT

Repeats text a given number of times.

Syntax

REPT(text, number_times)

Example

=REPT("*", 5)

#RIGHT

Extracts a substring from the right side of a string.

Syntax

RIGHT(text, [num_chars])

Example

=RIGHT(A2, 4)

#SEARCH

Finds the position of a substring (case-insensitive).

Syntax

SEARCH(find_text, within_text, [start_num])

Example

=SEARCH("ltd", A2)

#SUBSTITUTE

Replaces occurrences of old text with new text in a string.

Syntax

SUBSTITUTE(text, old_text, new_text)

Example

=SUBSTITUTE(A2, "-", "/")

#TEXTJOIN

Joins multiple strings using a delimiter, optionally ignoring empty cells.

Syntax

TEXTJOIN(delimiter, ignore_empty, text1, ...)

Example

=TEXTJOIN(", ", TRUE, A2:A10)

#TODAY

Returns the current ISO date.

Syntax

TODAY()

Example

=TODAY()

#TRIM

Removes leading, trailing, and excessive spaces between words.

Syntax

TRIM(text)

Example

=TRIM(A2)

#UPPER

Converts text to UPPERCASE.

Syntax

UPPER(cell)

Example

=UPPER(A2)

#VALUE

Converts a text string that represents a number to a number.

Syntax

VALUE(text)

Example

=VALUE("250,000")

#WEEKDAY

Returns day of the week as a number (1=Sunday, 7=Saturday).

Syntax

WEEKDAY(date)

Example

=WEEKDAY(TODAY())

#YEAR

Returns the year of a date.

Syntax

YEAR(date)

Example

=YEAR(TODAY())

#YEARFRAC

Calculates the fraction of the year between two dates.

Syntax

YEARFRAC(start_date, end_date)

Example

=YEARFRAC(A2, B2)