No, I meant F2.



Could you attach your file so I can tinker with it rather than have me recreate it? Who knows? Maybe we can figure it out together.

Thanks Gebobs,
Attached is a file. I appreciate your help. (Q: Can Pivot do the calculation internally so it can have separate Project Yr Field?)
This way its grouped together in the Pivot table and easier to work with.

Any and all help are welcome. Much appreciated!!

Attached Files

Today.xlsx (186.4 KB, 11 views)