Microsoft KB Archive/49759

Multiplan: Date Function Returns #NUM! Error PSS ID Number: Q49759 Article last modified on 03-28-1990 PSS database name: D_MPlan

4.00 4.01 4.20

MS-DOS

Summary:

Multiplan Version 4.00 displays the “#NUM!” error if the date entered does not exist. For instance, the function DATE(1980,8,34) results in a #NUM! error. The notation “#NUM!” in a cell is used in Multiplan to represent the illegal use of a function.

Multiplan was changed with Version 4.01 and 4.20 to accept fictional dates. These versions now accept DATE(1980,8,34) and interprets this entry as September 3, 1980. This change was made to allow greater flexibility.

Copyright Microsoft Corporation 1990.