convert period to a number and use in formula
I need to convert the period to a number (e.g. Oct = 1, Nov = 2, etc…) and then use that number in a formula to divide one of the amounts by that number. I was able to create a column that uses conditional formatting to convert the period to a number, but in my formula where i need to access that number, i get an error. Apparently i can't grab that number from Col B because it's not a data column. How do i do this?
Tagged:
0