Originally Posted by
gandreso
@Richard Buttrey - I totally agree with you Richard. The problem is that the data comes from an datasystem that has just that dateformat. But I agree, proper dates would be much more flexible.
Hi,
OK, understood, but notwithstanding I'd be inclined to have a pre-processing macro that creates a proper Excel date number from the datasystem 'dates in another column, and then use the proper date numbers in your macro so that you future proof and can use the dates for other analysis stuff should that ever be necessary.
So for instance with the system 'date' 201645 in A1 and assuming week 1 2016 is Monday 4 Jan
will return the date November 14 2016. Adjust the number 4 in the formula as appropriate for a different January 2016 w/c date.
Bookmarks