• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Populating dates (quarterly) in between two given quarterly dates

R

RobP

New Member
We have a data feed which contains two columns - date_started, date_ended - with a factor which needs to be applied to a data table between these dates - our data table contains columnar quarterly dates for the last say 5 years; so I need to list out the quarters between the date_started and date_ended in order to apply the factor the data table.

Any convenient way to do this?
 
Hi RobP,

Welcome to Chandoo.org forum.

Can you explain your idea on a sample file here. You can use Upload a file button just below where your type replies to the thread.

Regards,
 
Thanks Somendra for the quick reply; I actually think I've found the resolution via:
=IF($A$1+ROW(A1)>=$A$2-1,"",C1+1)

Though as it's quarters i just need to alter the progression specifically to the month.

It's just that the source file comes in an untrimmed, non-date format:

[ QTR/09/02]

which just makes the formula for this finicky, or I'll need to top and tail it through a macro first.
 
You must log in or register to reply here.
Back
Top