Bobthebuilder
Board Regular
- Joined
- May 2, 2002
- Messages
- 76
I have a date in the form mm/dd/yy
How do I simply extract just the year, so that when I create a pivot table, I dont get all unique entries which are behind the date. I tried formatting, but that doesn't work, the format is ignored and the source date is looked at!
Thanks
How do I simply extract just the year, so that when I create a pivot table, I dont get all unique entries which are behind the date. I tried formatting, but that doesn't work, the format is ignored and the source date is looked at!
Thanks