Software

Ask something
Question Locked

Excel Question

0 helpful
3 replies

by rhemraj

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a series of data... a column with dates stretching down month by month. I need to somehow pull only the quarterly dates onto a seperate column... so every March/June/Sept/Dec. What is the best way to do this? The dates go all the way back to 1988.

Thank you in advance for your help.

3 replies

by thumbsup2

Try this, assuming the dates you want to look at are in column A....

=IF(OR(MONTH(A1)=3,MONTH(A1)=6,MONTH(A1)=9,MONTH(A1)=12),A1,"")

Copy it down the entire column, then format all the cells in the column as a date because it will contain the Excel numeric value of a date.

by rhemraj

Thank you very much, i found this extremely helpful!!

I did, however, have another question... the column w/ the dates (column A) is accompanied by data in the following 3 columns (B,C,D), how can i get the data to correspond w/ the date? Would i need to do a vlookup for this? Thank you again for your time and help!!

This discussion is closed to new replies.