I created a pivot table dashboard, my work requires the projects to be sorted from 29 of one month to the 28th of the next. So all projects can be counted between those dates. I know I need a helper column but I cannot figure out how to set it up. Please anyone's help would be great.
Can you supply some sample data? Much easier to work out a fix if we can see what you have to start with.
I attached the file.
Hi Charles
Try this
Create a helper column M. In cell M2 enter:
=IF(DAY([@[WiFi Active]])>28,EOMONTH([@[WiFi Active]],0)+1,[@[WiFi Active]])
Basically any date from 29 onward is converted to the 1st of following month's date.
Hope this helps.
Sunny
Thank you Sunny, I will let you know how it goes.
I must not be doing something right. I am a novice at excel. Could someone walk me through using that above formula?