Formula to Pull data

Hi-

Please see attached spreadsheet. In the formula tab, I want to be able to reference my date in cell a2, and reutrn in celll c2 =Q1, AND IN D2=YTD, etc depending on the Month. Please let me know your suggestions.

Thanks
MiddleOfficeTEST.xlsx

You can put this formula in C2:

="Q"&INT((MONTH($A2)-1)/3)+1

and just:

YTD

in D2, and then copy both down to the bottom of the entries in column A.

Hope this helps.

Pete

Is there any way to reference the data tab, because I don't want to have to manually type in MTD for every new Month. Like Nov will be MTD this month, but next Month only Dec will be.

Ah, you didn't mention MTD in your first post. Put this formula in B2:

=IF(MONTH(A2)=MONTH(TODAY()),"MTD","")

then copy down.

Hope this helps.

Pete