Switching from Jan-1 yields 1/1/2006, should be 2007
 

I have a macro that merges multiple spreadsheets for input into a
forecast. The dates in the initial spreadsheet are in the format
"DEC-12". The forecast requires the dates in the format "12/12/2006".


I fixed that but the problem is this. Right now there are dates on for
January but my macro creates the dates as 1/1/2006 when it should be
1/1/2007.

Any thoughts on a formatting method apart from a brute force
programming solution checking to see if the data covers two years
(which I'm already working on)?

Switching from Jan-1 yields 1/1/2006, should be 2007
 

When the year isn't specified, Excel assumes the current year. So you need
to tell Excel you want January of next year, or you have to program
something.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Jason Lepack" wrote in message
s.com...
I have a macro that merges multiple spreadsheets for input into a
forecast. The dates in the initial spreadsheet are in the format
"DEC-12". The forecast requires the dates in the format "12/12/2006".


I fixed that but the problem is this. Right now there are dates on for
January but my macro creates the dates as 1/1/2006 when it should be
1/1/2007.

Any thoughts on a formatting method apart from a brute force
programming solution checking to see if the data covers two years
(which I'm already working on)?