I have a macro originally written in Windows Excel, but I converted it to Mac 2 or 3 years ago and it's been running happily on a monthly basis until the first time I tried to use it in December.
Processing is dependent on date, but it now crashes because it cannot recognise the date. I've tried formatting the cell in different ways, using cdate to convert the text to a date, and using value2 but nothing works.
I'm in the UK and my dates are formatted accordingly. Originally I used Custom format against the cell to show it as ddd dd/mm/yy. The cell would then show Sun 30/11/14, for example. In the input box at the top of the screen I can see the date value of 30/11/2014.
In VBA, if I refer to activecell.value and try to load it into a date variable, or display it in an input box I get '30/11/', and it really has lost the year. If I compare the year in this value to the year today, for instance, it fails with invalid format.
Wondering if my spreadsheet had somehow become corrupt, I closed it down and tried to build a simple similar process in a new workbook - still the same problem. I'm on Excel 2011 14.4.7, and my operating system is OS X Yosemite 10.10.1.
It feels like I'm the only one experiencing any problems, and this wasn't the only problem I started experiencing in December, but I've been able to work around the others.
It feels like this happened when I went to the OS X Yosemite but I can't be sure.
Any ideas?
Thanks in advance
