View Single Post
  #2   Report Post  
Spencer101 Spencer101 is offline
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by dpgreen View Post
Hi all, been a long time viewer of the forum and felt it was finally time I signed up, said hello, thanked you all and then asked you all for help.

I have a column with dates running down it. I need a column that will collect every third month and copy it into a column next to it. Effectively I need a column (without spaces) next to the date column that will show quarterly dates. I need this formula to be automated for future drag and autofill features when newer dates are added in.

If i've not been clear with what I am looking for then please ask any questions you need.

Thanks for your help in advance
Hi,

Do you mean you need it to sum all values that fall into each quarter?

Which version of Excel are you using?

Any chance of a sample workbook with dummy data?

S.