2007 date picker 1900!

[berbchid]

Ok, so I have a LOT of dates to add to a number of cells in various worksheets. I'm creating a userform to do this, and It works so far... except when I don't want any dates.. a 'null' value... the date cells are ending up as January 1900! I've been working on this form for a while so a fresh set of eyes to tell me where I'm going wrong would be a big help. I know it's probably something simple, but I just can't seem to think my way out of it right now.

Attachment 286451

[protonLeah]

Try:

=IF(ISNUMBER(E7),E7+365,"")

[berbchid]

Thanks for the response.
That may work for the formulas, but the problem I'm having is between the userform values and what gets entered into each cell.
Currently, the code goes along cell by cell in the row, and fills with the value from the appropriate control, regardless of what that value is.
What I need to have happen is to cycle through the control values, and only enter the ones that are NOT null, because I'm pretty sure that the January 1/1900 issue is due to a null value in the date pickers. I'm just not sure how to do this. Again, any help is much appreciated.

[berbchid]

I fixed it.. sort of. Since the end user has 2010 anyway, I changed the date picker controls for text boxes, and now the form works completely. I've included a copy in case anyone else wants to see it, or if anyone has ideas for tweaking it. The workbook its on is a small sample. The real file has hundreds of employees across 12 different worksheets. Any ideas on making this work as fast as possible for the end user would be much appreciated.

tickettemp1.xlsm