next up previous contents index
Next: 4.7 Entering Formulas Up: 4.6 Entering Dates and Previous: 4.6 Entering Dates and

4.6.1 Using Date Functions to Enter Dates

Another way to enter dates is to use one of the NExS date functions. You can use the Format dialog box from the Edit menu to choose how the date should appear in the cell.


For more information on Date and Time Functions, please refer to Chapter 7, Built-in Functions, and also the Function Reference in Appendix A.

NExS internally stores date and time information using the same convention as other popular spreadsheet programs: Dates are represented as an integer equal to the number of days since December 31, 1899. Times are represented as fractions of a day, starting at midnight. For example, 6:00 AM is stored as 0.25 (a quarter of a 24-hour day). Using this convention, date and time values may be used together. For example, the date/time value 1.25 corresponds to 6:00:00 AM, January 1, 1900.


You can use date values in calculations. For example, subtracting 05-Oct-91 from 10-Oct-91 yields a value of 5 days.


next up previous contents index
Next: 4.7 Entering Formulas Up: 4.6 Entering Dates and Previous: 4.6 Entering Dates and

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999