Using DATE in Excel 2003

**ExcelDog** · 02-17-2010, 05:15 AM

Hi,

I am new to Excel and we use version 2003 at work. Currently I need to create a date using the DATE() function, and have been experimenting with:

=DATE(YEAR(NOW()), MONTH(NOW()), DAY(NOW()))

to try and generate today's date as an exercise in using the DATE function without success.

Where am I going wrong please?

**martindwilson** · 02-17-2010, 05:19 AM

=DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW())) works for me
in fact i just copied pasted yours into my sheet and it gave 17/02/2010

**ExcelDog** · 02-17-2010, 05:24 AM

Originally Posted by martindwilson

=DATE(YEAR(NOW()),MONTH(NOW()),DAY(NOW())) works for me
in fact i just copied pasted yours into my sheet and it gave 17/02/2010

Hmmm.... If I cut and paste this I get the message 'The formula you typed contains an error'

**ExcelDog** · 02-17-2010, 07:10 AM

FOUND IT! The Date() function wanted a pipe character as a parameter separation, not a comma as I first thought. I had my list separator set to the pipe character in the advanced section of my local language settings. Sorry for that.