Difference between revisions of "Manuals/calci/NOW"
Jump to navigation
Jump to search
(Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...") |
|||
| Line 1: | Line 1: | ||
| − | + | =NOW()= | |
| − | + | NOW() displays the serial number of current date and time. | |
| − | + | == Description == | |
| − | |||
| − | |||
| − | + | NOW() | |
| − | + | *Dates are stored in the form of sequential numbers as to be used in calculations. e.g. January 1, 1900 is stored as serial number 1 and so on. | |
| − | + | *Numbers to the left of decimal point represent serial number of current date. | |
| − | + | *Numbers to the right of decimal point represent serial number of current time. | |
| − | + | *This function does not have any arguments. | |
| − | + | *TODAY() function can be used to display the serial number of today's date only. | |
| − | + | == Examples == | |
| − | + | <div id="6SpaceContent" class="zcontent" align="left"> | |
| − | |||
| − | <div id=" | ||
| − | + | {| id="TABLE3" class="SpreadSheet blue" | |
| + | |- class="even" | ||
| + | | class=" " | '''Function''' | ||
| + | | class=" " | '''Output''' | ||
| − | + | |- class="odd" | |
| − | - | + | | class="sshl_f" |NOW() |
| − | + | | class="sshl_f" |41722.70444444445 | |
| − | |||
| − | |||
| − | + | |- class="even" | |
| − | + | | class="sshl_f" | | |
| − | + | | class="sshl_f" | | |
| − | + | } | |
| − | |||
| − | |||
| − | + | == See Also == | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *[[Manuals/calci/DATE | DATE]] | |
| − | + | *[[Manuals/calci/TIME | TIME]] | |
| − | + | *[[Manuals/calci/TODAY | TODAY]] | |
| − | + | ==References== | |
| − | + | *[http://en.wikipedia.org/wiki/Wikipedia:Manual_of_Style/Dates_and_numbers#Date_formats Date Formats] | |
| − | |||
Revision as of 15:59, 24 March 2014
NOW()
NOW() displays the serial number of current date and time.
Description
NOW()
- Dates are stored in the form of sequential numbers as to be used in calculations. e.g. January 1, 1900 is stored as serial number 1 and so on.
- Numbers to the left of decimal point represent serial number of current date.
- Numbers to the right of decimal point represent serial number of current time.
- This function does not have any arguments.
- TODAY() function can be used to display the serial number of today's date only.
Examples
| Function | Output |
| NOW() | 41722.70444444445 |
|
} See AlsoReferences |