I have tasks with various dates within a given month. I'm wanting to group all tasks by Month so that I can see all tasks that fall into the respective month and group them in a report and have them sort by the month (Jan, Feb, Mer, etc.) However, SS is sorting by the month name (July, June, September, etc.)
I found the formula to return the Month and year from a date cell, but I cant find one that adds the day as well. My thinking is if the day was added to the Month and year in the same cell, this might fix the problem, but I'm not sure, nor do I even know how to try...... :)
