Forum Discussion
if statements
I have 12 sheets one for each month of the year. On December on want to show just the year (2019) inA1 then in January I want to show the year (2020) in A1. I would like to do this using and if state...
How to organize data better it depends. On volume and granularity of data and on goals of course. As for direct question - if your sheet starts from Jan 2019 and after that go sequentially, to show year in the A1 you may use
=INT((SHEET()-1)/12)+2019To show both month and year
=TEXT(DATE(INT((SHEET()-1)/12)+2019,MOD(SHEET()-1,12)+1,1),"mmm yyyy")SergeiBaklanthank you
