On 05/02/2013 09:52 PM, vsharris wrote:
I have a spreadsheet with three columns: year, month, day. In the 4th column
I use the DATE() function to create a date from these columns. It works fine
if there are valid data, but if the month and day column are empty, the
results are surprising.
For
I have a spreadsheet with three columns: year, month, day. In the 4th column
I use the DATE() function to create a date from these columns. It works fine
if there are valid data, but if the month and day column are empty, the
results are surprising.
For example:
DATE(1995,blank,blank)
is the
At 18:52 02/05/2013 -0700, V. S. Harris wrote:
I have a spreadsheet with three columns: year, month, day. In the
4th column I use the DATE() function to create a date from these
columns. It works fine if there are valid data, but if the month and
day column are empty, the results are
