This one should be easy for you pros out there.
My workbook contains one sheet called master and then one sheet for every month in the year, January 11, February 11 etc. On the "master" sheet in A1 is today's date (input as =TODAY() and formatted to look like dd-mmm-yy) In cell A2 of the master sheet I want to make an IF statement that checks what the date is today and then goes to the appropriate month sheet to display the information in cell O8 of that month. The info I want displayed is always in the same cell across the different month's and the day doesn't its just the month.
I tried something along the lines of IF(31-Jan-11>=A1>=01-Jan-11,='January'!O8,"") Not much luck there, and if I had had any luck in the 'if false part of the argument I was going to put in the same criteria just for feb and so on... There has to be something easier or if not why won't it work.
Can anyone lend me a hand with this?
My workbook contains one sheet called master and then one sheet for every month in the year, January 11, February 11 etc. On the "master" sheet in A1 is today's date (input as =TODAY() and formatted to look like dd-mmm-yy) In cell A2 of the master sheet I want to make an IF statement that checks what the date is today and then goes to the appropriate month sheet to display the information in cell O8 of that month. The info I want displayed is always in the same cell across the different month's and the day doesn't its just the month.
I tried something along the lines of IF(31-Jan-11>=A1>=01-Jan-11,='January'!O8,"") Not much luck there, and if I had had any luck in the 'if false part of the argument I was going to put in the same criteria just for feb and so on... There has to be something easier or if not why won't it work.
Can anyone lend me a hand with this?
