How to Calculate a Calendar Quarter for a Date

[@DannyRocksExcels]

My pleasure. I am happy that my videos help you to improve your skills. Sincerely, Danny Rocks The Company Rocks

[@DannyRocksExcels]

That's amazing! It works! I will have to study the logic of it to understand how this operates. Thanks for sharing this tip! Danny Rocks The Company Rocks

[@_Sunil.M]

Dear Danny, Thank you for ur wonderful and helpful uploads..Really helpful...Thx a ton..keep going ..cheers

[@mooncake9880]

Thank You Very Much Sir.

[@DannyRocksExcels]

Yes, please. email me your worksheet to look at. Danny Rocks The Company Rocks

[@DannyRocksExcels]

Hello - I am out of town all week. You can find my email address on my business card, which is the first screen of every video that I have posted here on KZbin. Danny Rocks The Company Rocks

[@iluvmonket]

Danny Rocks I need your help! How can I in touch with you?

[@HBeretta]

formula below represents a cell reflecting days hrs and mins or (15 d 0:45). cells h4 and c4 reflect dates in this format->07/01/2012 and cells d4 and i4 are drop down cells of times in 15 min increments shown->8:45 AM. Now if i4 is less than d4 for example cell i4=8:45 AM and d4 is 10:45 AM the formula works. but if i4 is greater than d4 i get a #VALUE! error. i need help! i can email you the worksheet. thanks! =IF(H4="","",IF(I4="","",TEXT(H4-C4,"d")&" d "&TEXT(I4-D4,"h:mm")))