Hello,
I would like to calculate quarterly or every 3 months the number of referrals I have had to a service. I have a column in which I enter the date the person entered the service. I would like to formulate the date cells to a different colour if they occurred in the last 3 months. Or if it is possible to create a total for the number of referrals occurring in the last quarter.
I can see you can do conditional cell formatting for dates occurring in the last month but I don't know how to make it calculate 3 months.
I'm enjoying trying to use excel to make my quarterly stats calculations easier and have managed to do most things, but this is frustrating me!
Any help would be appreciated
Bookmarks