Developer Forum

How do I enter year month day separately and combine them. only year may be
enetered.

Use the Dateserial() function

MyYear = 2005
MyMonth = 5
MyDay = 13

=Dateserial(MyYear, MyMonth, MyDay)

Thanks, this led to a different approach to the problem, using this function.
As Klatuu has written elsewher, there are many ways to skin a cat.

Thanks for the kind words. I am pleased, my cats are nervous.