Quarter function based on current date

S

Steele1978

I am in need of a function that will return quarters past quarter
based upon the existing date. For example, if todays current date i
3/31/12 and I am working with a future date of 3/31/16 I need a functio
that would return quarter 16 (being 16 quarters form my "current date")
and further any date between 1/1/18 and 3/31/18 would return a quarte
24 (being 24 quarters form my "current date"). I need this to b
accurate through 40 quarters. Please help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function for returning quarter based on current date? 4
Return the current Yearly Quarter based on date 2
End of Quarter Based on Fiscal Year 2
INDEX MATCH SMALL 13
Date query 4
If cell = now – current Qtr – 28 days then RED 3
Calculating quarters of a year. 4
Date To Quarter, Plus Next 3 Quarters 1

Top