Susan,

Have you tried DateSerial yet? The syntax is DateSerial(Year, Month, Day), and the result is independent of the system's date format settings. Using the Date function to return today's date, you could try:

sDate = DateSerial(Year(Date), Month(Date), Day(Date))

In addition, I found that the following website had some helpful tips about working with dates in Excel:

http://www.ozgrid.com/Excel/free-tra...a1lesson14.htm

Good luck,

Ben