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
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
Microsoft ExcelMicrosoft Office
Last Comment
Flora Edwards
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thank you very much everyone.
Alan, you nailed it with your formula. it worked.
![2017-11-14-15_39_05-EE.xlsx---Excel.png]()
Alan, you nailed it with your formula. it worked.
ASKER
Thanks Everyone
ASKER
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
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
many thanks. yes i am sorry. that was a typo.