Hello.
This is probably really simple, but I have 2 formulas that need to be combined into one.
Can this be done?
=OFFSET('Previous Year'!C14,0,MATCH(DATE(YEAR(D9+1)-1,MONTH(D9+1),DAY(D9+1)),'Previous Year'!$C$9:$IV$9,0)-1)
=OFFSET('Previous Year'!C61,0,MATCH(DATE(YEAR($D$9+1)-1,MONTH($D$9+1),DAY($D$9+1)),'Previous Year'!$C$56:$IV$56,0)-1)
Any help would be appreciated.
Cheers
Bookmarks