How do I let my program know that the user is going to input a date into a textbox? The objective is to calculate portfolio returns but cashflows in and out of the portfolio are weighted by the number of days that they were in the portfolio which means I need to be able to subtract two dates to give me the number of days. When the user inputs something like "11/25/2009" there doesn't seem to be a way to let the userform know that this is in date format rather than just a literal string.
Bookmarks