Problem with dates

[Harry Covair]

Hi the forum,

In a procedure, I compute the monthly average of temperature between the years 1833 and 2015.

Everything goes fine until 12/31/1929. When switching to 01/01/1930, 1930 becomes 30 and is considered as being less than 1900.

Below you will find in the pictures the values in the Excel sheet and in VBA.

The link to access the file:http://www.cjoint.com/c/FEekCs6ddDZ

I will appreciate if a member of the forum could help me to solve this problem.

Thanks in advance.

Harry

 

[Debaser]

VBA can handle dates prior to 1900 so you can just use Year, Month etc.

 

[Harry Covair]

Hi Debaser,
Thanks for your answer.
I didn't know thie properties.
Have a nice day
Harry