Link to home
Create AccountLog in
Avatar of Flora Edwards
Flora EdwardsFlag for Sweden

asked on

how to generate quarters with formulas in Excel

Please see attached file.

i have the cells with green background that are my start dates and end dates.  the cells highlighted in yellow are the quarters which i generate manually.  can there be a formula that when i copy to other cells, it generates those quarters for me, instead of all this manual work.  there has to be a better way with formula, but i could not find anything in google.

any help is appreciated.
EE.xlsx
SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Flora Edwards

ASKER

Ryan,

many thanks.  yes i am sorry. that was a typo.
thank you very much everyone.


Alan, you nailed it with your formula. it worked.
User generated image
Thanks Everyone
Hi Alan,

i faced problem with your formula on the computer with american date format MM/DD/YY

i posted a new question for this. link is https://www.experts-exchange.com/questions/29072413/Date-formula-do-not-work-in-Machines-with-american-date-format.html