Hi All!
I am trying to understand this function in an excel sheet sent to me:
Can someone A) explain what is happening and B) What is the MONTH funtion doing and C) What the set of quotations do when they have nothing in between them?![]()
=IF(OFFSET(D12,0,(MONTH(Month)-1)*12)="","",OFFSET(D12,0,(MONTH(Month)-1)*12))
Thanks in advance!
Bookmarks