![]() The Date category located in the Format Cells box (shown above) lists many variation that a date can be written. Calculating the Days Writing the Dateīefore you can use a date in a calculation it must be written in a format that Calc understands as a date. Every date is really a serial number, that's how Calc can use dates in a calculation. If that happens Use the Format Cells menu and choose Date from the category list to convert the serial number back to a date format of your choice. Occasionally when using these date functions instead of a date being returned you may get a long series of numbers, known as a serial number. Unlike most Calc functions there are no arguments in the brackets of these two functions, in other words the brackets () are empty. NOW function: syntax: =NOW() - always returns the current date and updates the current time after every entry/calculation. ![]()
0 Comments
Leave a Reply. |