excel_helps!
New Member
- Joined
- Jan 20, 2010
- Messages
- 11
Hi There,
I have a specific work that I am trying to resolve but somehow am unable to solve the same.
so basically in col A and Col B I have project start date and project end date. i have minisheet attached below.
what help i need from the group is to update 4 columns using Col A and Col B
in Col C - if the project start date is 1st day of Qtr then in which Qtr i am in ? (in number for ex: 2, 3, 4)
in col D - how many Qtrs will the project run for?
in col E - if i am in 3rd Qtr what is the start date of the Qtr
in col F - if i am in 3rd Qtr what is the End date of the Qtr
If you guys can help me with this i will be out of this Jam and would really appreciate the help. i am Stuck and my work is not progressing.
Thank you so much in advance.
regards,
M
I have a specific work that I am trying to resolve but somehow am unable to solve the same.
so basically in col A and Col B I have project start date and project end date. i have minisheet attached below.
what help i need from the group is to update 4 columns using Col A and Col B
in Col C - if the project start date is 1st day of Qtr then in which Qtr i am in ? (in number for ex: 2, 3, 4)
in col D - how many Qtrs will the project run for?
in col E - if i am in 3rd Qtr what is the start date of the Qtr
in col F - if i am in 3rd Qtr what is the End date of the Qtr
If you guys can help me with this i will be out of this Jam and would really appreciate the help. i am Stuck and my work is not progressing.
Thank you so much in advance.
regards,
M
sample.xlsb | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | From project start date | |||||||
2 | Project Start Date | ProjectEndDate | Qtr No. | Total Qtrs between start and end date | Start date of current Qtr | End date of current Qtr | ||
3 | 7/1/2021 | 6/30/2023 | ||||||
4 | 7/1/2021 | 5/31/2022 | ||||||
5 | 1/1/2021 | 2/28/2022 | ||||||
6 | 10/1/2020 | 11/30/2022 | ||||||
7 | 10/1/2021 | 9/30/2023 | ||||||
8 | 10/1/2020 | 12/31/2022 | ||||||
9 | 4/15/2021 | 5/31/2022 | ||||||
10 | 10/1/2020 | 9/30/2022 | ||||||
11 | 7/1/2020 | 12/31/2021 | ||||||
12 | 12/15/2020 | 12/31/2023 | ||||||
Sheet1 |