Forum Discussion
Creating an Exact Calendar Lookup Table
I'm creating a pivot table that summarizes energy usage recorded at a site vs. what the billing company says was actually used at the site. I've ran into trouble having both sets of data display,...
I'd round minutes in calendar using
=MROUND(A2+TIME(0,15,0),"00:15")Second, in the bill table some date show next date, not sure why
If simply re-enter it'll be as in formula bar. With changing the date on Apr 01 PivotTable is