Forum Discussion
I need a (complicated?) formula
I have created an excel databased from which I have a pivot table to summarize employee time data. This pivot table is based on dates within a two week period of time. It then rounds the time. I ta...
Good Morning.
As for Resizing your range. Look into converting your range to a table. I use 2016 and it has excel inherently just knows your modifying your table and youe can easily resize it off of the 'design' Ribbon.
As for identifying dates. Create a column coilumns to the right of your data and create a formula in that column that calssify's a date as in falling inot a payperiod. Then in the pivottable add a sum by period.
I can attach an example if you would like.
Good luck ..
Joe