vba code for making 3 month intervals (quarters) using date

[nlink222]

Hi,

I'm new to this forum and can't figure out how to do something. I have six years of data that contain dates for when certain events happened (dd/mm/yyyy). I need to create variables indicating when those events happened by 3 month intervals (quarters), BUT I need those quarters to range from 1-24. For example, for 2009 the first 4 variables would be 1-4, but the the first quarter for 2010 would be 5, second quarter would be 6, etc.

The current code I have is =ROUNDUP(MONTH(F2)/3,0) where F2 is my date, but this only returns 1-4 within 2009, 2010, etc individually, and I need them 1-24. Does anyone know if there's a way to do this? I've been searching online and asking friends and I can't figure it out, so any help is really appreciated!

Thanks and Happy Holidays!!!

 

[Roger Govier]

Just add to your formula +4*(YEAR(F2)-2009)

 

[nlink222]

that worked, thank you so much!!!!!!!