DATESBEFORE1900

Returns the results of adding and subtracting dates before 1900 which are represented as text.

DATESBEFORE1900

Returns a text string of a particular year, month and day
Supports pre 1900.
year
month
day
format - (Optional) Allows you to change the date format that is returned, default is "dd/mm/yyyy"

DATESBEFORE1900_ADD

Returns a text string given a text date incremented by a number of days.

DATESBEFORE1900_DIF

Returns the number of days (months or years) between two text dates

DATESBEFORE1900_DAY

Returns an integer that represents the day from a text date.

DATESBEFORE1900_MONTH

Returns an integer that represents the month from a text date.

DATESBEFORE1900_YEAR

Returns an integer that represents the year from a text date.

DATESBEFORE1900_WEEKDAY

Returns the day of the week for a given text date.