Hi there I have a date in cell A1 that I enter manually. In cell A2 I have the following formula that MOD's the date in A1. When I enter a date pre 1900, it returns error. I am aware of the Xdate function. It allows me to enter the date, but my formula in cell A2 does not work. Is there something I need to add to that formula in cell A2?

Please Login or Register  to view this content.
Thanks.