Hiya,

I am using a datetime picker from a userform and on change I populate a cell
on a spreadsheet which is using the 1904 date system (this is because it
needs to be able to view negative times).

The problem is that when the date is transferred from the date picker to the
spreadsheet, it is 4 years and 1 day forward of what it should be. Is there a
way of changing the date picker / VB times so that they are in the 1904
system?

Thanks,

Basil