Hello once again. I need you assistance.
I have a Pivot Table,
column G is the Min Date
column H is the Max date
I'd like to add a calculation in column I that will show me the # of weeks between the dates in column G and H.
Can I just add a column I with the following formula: =ROUND((H4-G4)/7,0) or can the pivot table do this automatically for me?
Please advise. Thanks!!
I have a Pivot Table,
column G is the Min Date
column H is the Max date
Job Funct Name | Mgr Level | Min of Eff Start Dt | Max of Eff Start Dt2 | |
Stores | Non-Exempt Non-Manager | 6/20/2021 | 1/9/2022 | |
Stores | Non-Exempt Non-Manager | 2/9/2020 | 2/9/2020 | |
Stores | Non-Exempt Non-Manager | 7/1/2018 | 5/12/2019 | |
Stores | Non-Exempt Non-Manager | 12/29/2019 | 12/29/2019 | |
Stores | Manager | 3/16/2021 | 5/17/2021 | |
Stores | Non-Exempt Non-Manager | 7/1/2018 | 7/1/2018 | |
Stores | Non-Exempt Non-Manager | 10/26/2020 | 11/30/2020 | |
Stores | Non-Exempt Manager | 7/1/2018 | 7/1/2018 | |
Stores | Non-Exempt Manager | 10/28/2018 | 11/14/2020 | |
Stores | Manager | 4/14/2019 | 3/14/2021 | |
Stores | Non-Exempt Manager | 4/26/2020 | 5/3/2020 | |
Stores | Non-Exempt Manager | 7/1/2018 | 3/22/2020 | |
Stores | Non-Exempt Manager | 2/9/2020 | 5/17/2020 | |
Stores | Non-Exempt Manager | 5/8/2022 | 5/8/2022 | |
Stores | Non-Exempt Manager | 7/1/2018 | 7/1/2018 | |
Stores | Non-Exempt Manager | 4/4/2021 | 3/28/2022 | |
Stores | Non-Exempt Manager | 7/1/2018 | 7/1/2018 | |
Warehouse - Operations | Non-Exempt Non-Manager | 7/1/2018 | 12/19/2021 | |
Warehouse - Operations | Non-Exempt Non-Manager | 12/19/2021 | 1/2/2022 | |
Warehouse - Operations | Senior manager | 4/7/2019 | 12/19/2021 | |
Warehouse - Operations | Senior manager | 12/19/2021 | 12/19/2021 | |
Warehouse - Operations | Senior manager | 2/3/2019 | 3/10/2019 | |
Stores | Non-Exempt Manager | 7/1/2018 | 3/19/2022 | |
Stores | Non-Exempt Non-Manager | 7/1/2018 | 7/6/2018 | |
I'd like to add a calculation in column I that will show me the # of weeks between the dates in column G and H.
Can I just add a column I with the following formula: =ROUND((H4-G4)/7,0) or can the pivot table do this automatically for me?
Please advise. Thanks!!