#Openoffice calc date format serial#
#Openoffice calc date format iso#

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.

#Openoffice calc date format serial#

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.

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. 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). If we only enter 2 digits of the year (for example 07 instead of 2007) Calc needs to know whether we mean 2007 or 1907. In Tools - Options - General you may set the range of years for which Calc will recognise years given 2 digits. Some of Calc's date and time functions return a 'date' or a 'time' ( for example TODAY() ). This is simply the date-time serial number, but if the cell is unformatted, Calc will display the date or time rather than a number format.

#Openoffice calc date format iso#

The descriptions of the Calc functions in these help pages use the international standard ISO date format for clarity, because this does not depend on locale for example, 23rd May 2009 is shown as. Īll major spreadsheets (including Calc) handle dates and times in a similar way, for historical reasons, but this can be a bit cumbersome. Simply add 14 days, and format the cell as a date to display it correctly. How many days between two dates DAYS('23Jan08' '9Jan08') returns 14, the number of days - however you can simply subtract one date from the other for example if cell A1 contains 23Jan08 and cell A2 contains 9Jan08, A1-A2 also returns 14.

Use NETWORKDAYS if you wish to know how many working days for example NETWORKDAYS(A2 A1) returns 11, the number of whole workdays (including both end days but excluding weekends). NETWORKDAYS can also take account of other non-working days.Ī column with dates a week apart Format the column to display dates as you prefer. #Open office date format remove software#.#Open office date format remove serial#.#Open office date format remove serial number#.