How do I enter year month day separately and combine them

[Ian on Cowan]

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

 

[Klatuu]

Use the Dateserial() function

MyYear = 2005
MyMonth = 5
MyDay = 13

=Dateserial(MyYear, MyMonth, MyDay)

 

[Ian on Cowan]

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.

 

[Klatuu]

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