funcation

From HELP:

NOW
Returns the serial number of the current date and time.

Syntax
NOW( )

Remarks
Microsoft Excel stores dates as sequential serial numbers so that it can
perform calculations on them. Excel stores January 1, 1900, as serial number
1 if your workbook uses the 1900 date system. If your workbook uses the 1904
date system, Excel stores January 1, 1904, as serial number 0 (January 2,
1904, is serial number 1). For example, in the 1900 date system, Excel
stores January 1, 1998, as serial number 35796 because it is 35,795 days
after January 1, 1900. Learn more about how Microsoft Excel stores dates and
times.

Microsoft Excel for Windows and Microsoft Excel for the Macintosh use
different default date systems. Excel for Windows uses the 1900 date system,
in which serial numbers correspond to the dates January 1, 1900, through
December 31, 9999. Excel for the Macintosh uses the 1904 date system, in
which serial numbers correspond to the dates January 1, 1904, through
December 31, 9999.

Numbers to the right of the decimal point in the serial number represent the
time; numbers to the left represent the date. For example, in the 1900 date
system, the serial number 367.5 represents the date-time combination 12:00
P.M., January 1, 1901.

You can change the date system by selecting or clearing the 1904 date system
check box on the Calculation tab of the Options command (Tools menu).

The date system is changed automatically when you open a document from
another platform. For example, if you are working in Excel for Windows and
you open a document created in Excel for the Macintosh, the 1904 date system
check box is selected automatically.

The NOW function changes only when the worksheet is calculated or when a
macro that contains the function is run. It is not updated continuously.

Examples
If you are using the 1900 date system and your computer's built-in clock is
set to 12:30:00 P.M., 1-Jan-1987, then:
NOW() equals 31778.52083
Ten minutes later:
NOW() equals 31778.52778

hth
Vaya con Dios,
Chuck, CABGx3



"wassim" <[email protected]> wrote in message
news:[email protected]...
> i would like about this funcation
> now
> all thing

From HELP:

NOW
Returns the serial number of the current date and time.

Syntax
NOW( )

Remarks
Microsoft Excel stores dates as sequential serial numbers so that it can
perform calculations on them. Excel stores January 1, 1900, as serial number
1 if your workbook uses the 1900 date system. If your workbook uses the 1904
date system, Excel stores January 1, 1904, as serial number 0 (January 2,
1904, is serial number 1). For example, in the 1900 date system, Excel
stores January 1, 1998, as serial number 35796 because it is 35,795 days
after January 1, 1900. Learn more about how Microsoft Excel stores dates and
times.

Microsoft Excel for Windows and Microsoft Excel for the Macintosh use
different default date systems. Excel for Windows uses the 1900 date system,
in which serial numbers correspond to the dates January 1, 1900, through
December 31, 9999. Excel for the Macintosh uses the 1904 date system, in
which serial numbers correspond to the dates January 1, 1904, through
December 31, 9999.

Numbers to the right of the decimal point in the serial number represent the
time; numbers to the left represent the date. For example, in the 1900 date
system, the serial number 367.5 represents the date-time combination 12:00
P.M., January 1, 1901.

You can change the date system by selecting or clearing the 1904 date system
check box on the Calculation tab of the Options command (Tools menu).

The date system is changed automatically when you open a document from
another platform. For example, if you are working in Excel for Windows and
you open a document created in Excel for the Macintosh, the 1904 date system
check box is selected automatically.

The NOW function changes only when the worksheet is calculated or when a
macro that contains the function is run. It is not updated continuously.

Examples
If you are using the 1900 date system and your computer's built-in clock is
set to 12:30:00 P.M., 1-Jan-1987, then:
NOW() equals 31778.52083
Ten minutes later:
NOW() equals 31778.52778

hth
Vaya con Dios,
Chuck, CABGx3



"wassim" <[email protected]> wrote in message
news:[email protected]...
> i would like about this funcation
> now
> all thing

i would like about this funcation
now
all thing

From HELP:

NOW
Returns the serial number of the current date and time.

Syntax
NOW( )

Remarks
Microsoft Excel stores dates as sequential serial numbers so that it can
perform calculations on them. Excel stores January 1, 1900, as serial number
1 if your workbook uses the 1900 date system. If your workbook uses the 1904
date system, Excel stores January 1, 1904, as serial number 0 (January 2,
1904, is serial number 1). For example, in the 1900 date system, Excel
stores January 1, 1998, as serial number 35796 because it is 35,795 days
after January 1, 1900. Learn more about how Microsoft Excel stores dates and
times.

Microsoft Excel for Windows and Microsoft Excel for the Macintosh use
different default date systems. Excel for Windows uses the 1900 date system,
in which serial numbers correspond to the dates January 1, 1900, through
December 31, 9999. Excel for the Macintosh uses the 1904 date system, in
which serial numbers correspond to the dates January 1, 1904, through
December 31, 9999.

Numbers to the right of the decimal point in the serial number represent the
time; numbers to the left represent the date. For example, in the 1900 date
system, the serial number 367.5 represents the date-time combination 12:00
P.M., January 1, 1901.

You can change the date system by selecting or clearing the 1904 date system
check box on the Calculation tab of the Options command (Tools menu).

The date system is changed automatically when you open a document from
another platform. For example, if you are working in Excel for Windows and
you open a document created in Excel for the Macintosh, the 1904 date system
check box is selected automatically.

The NOW function changes only when the worksheet is calculated or when a
macro that contains the function is run. It is not updated continuously.

Examples
If you are using the 1900 date system and your computer's built-in clock is
set to 12:30:00 P.M., 1-Jan-1987, then:
NOW() equals 31778.52083
Ten minutes later:
NOW() equals 31778.52778

hth
Vaya con Dios,
Chuck, CABGx3



"wassim" <[email protected]> wrote in message
news:[email protected]...
> i would like about this funcation
> now
> all thing