I am trying to reverse engineer this formula:
=INDIRECT(TEXT(DATEVALUE($A$3),"mmmm")) Hours
I am unsure why "Hours" is at the end of the formula. The formula references a date in A3 (October 2022), but I am unsure why it needs to be in the "mmmm" format. The result of the formula in the cell is 177. I think it may be trying to figure out how many working hours (8 hours a day Monday-Friday) are in the referenced month, but I want to understand exactly how this formula works.
=INDIRECT(TEXT(DATEVALUE($A$3),"mmmm")) Hours
I am unsure why "Hours" is at the end of the formula. The formula references a date in A3 (October 2022), but I am unsure why it needs to be in the "mmmm" format. The result of the formula in the cell is 177. I think it may be trying to figure out how many working hours (8 hours a day Monday-Friday) are in the referenced month, but I want to understand exactly how this formula works.