Thomas Kuriakose
Active Member
Respected Sirs,
We need a formula to populate quarters dynamically on range of dates based on an input date for the next six quarters.
Kindly find attached a sample file with the input and requirement
For example if the input date is 09/15/2022 (B2) and the range of dates start with 10/18/2016 (A6) then this will be Q1 and go on until Q6.
Thank you very much for your support and guidance always,
with regards,
thomas
We need a formula to populate quarters dynamically on range of dates based on an input date for the next six quarters.
Kindly find attached a sample file with the input and requirement
For example if the input date is 09/15/2022 (B2) and the range of dates start with 10/18/2016 (A6) then this will be Q1 and go on until Q6.
Thank you very much for your support and guidance always,
with regards,
thomas