#Openoffice calc convert text to number serial number
#Openoffice calc convert text to number serial

Calc recognises a wide range of possible date entries - for example 25-Dec-07, 25 December 2007, Dec 25 07, and 25/12/07 or 12/25/07 (these last two depend on the date system you use - whether days or months are written first).

#Openoffice calc convert text to number serial

Therefore Calc tries to do this for us: if we enter 25Dec07, Calc recognises that this is a date, converts it to the date-time serial number, and sets the format to display as a date. It would be extremely inconvenient if, in order to enter a date in a cell, we had to work out the date-time serial number, enter it and then change the display format. Times are represented as a fraction of a day - for example 0.5 is half a day, or 12 hours, or 12 noon 0.25 is a quarter of a day, or 6 am. The default (normal) starting date is 30 December 1899 choose Tools - Options - Calc - Calculate to change this to 1 January 1904 for Apple software, or 1 January 1900 for old StarCalc 1.0 software if necessary.

#Openoffice calc convert text to number serial number

The date-time serial number is simply the number of days that have passed since a set starting date. We may enter 39441 in a cell, and then (selecting Format - Cells.) choose a date format to display the number as a date.Īlthough a number representing a date / time is the same as any other number (except that we choose to display it as a date or time) it may be helpful to use the term 'date-time serial number'. For example the number 39441 may represent the date 25Dec07. In Calc, dates and times are represented by numbers. Returns the number of years including fraction between two dates. Returns the date of Easter Sunday in a given year. Returns the number of years between two dates. Returns the number of months between two dates. Returns the non-ISO week number of a given date. Returns the ISO week number of a given date. Returns the number of weeks in the year of the given date. Returns the number of weeks between two dates. Returns the number of days in the year of the given date. Returns the number of days in the month of the given date.

Returns the number of days between two dates, using the 360 day year. Returns the number of days between two dates. Returns the number of workdays between two dates. Returns a date a given number of workdays away. Returns the date of the last day of a month. Returns a date-time serial number from a text time. Returns the time, given hours, minutes and seconds. Returns a date-time serial number from a text date. Returns the date, given the year, month and day of the month. Returns the day of the week for a given date.