Date format

[R0ckie]

Have a common date string as 05/11/2018 and need to change to May-18. This is easy to do with a format change but the problem is it remembers the actual date. So May-18 could be multiple dates in May. Not a problem until I want to do a pivot table by Month/Year. Then I of course get multiple lines for the same month when I'm looking for a total. Thanks in advance.

 

[cfi03]

On the assumption that your initial date is actually a date serial number, rather than a date string, as you have indicated, you could change all occurrences of the initial date to the end of the month using =eomonth(initial date serial number, 0)

 

[Norie]

In a pivot table you can group date fields by month/year.