A1 contains function TODAY(). I would like a formula in A2 which yield the number of the month preceding, for instance if today's date is May 9, the formula in A2 would yield 4. If today's date is any day in June, the formula in A2 would yield 5, and so on. I will need to be able to divide other sets of numbers by the number in A2.
Any help will be appreciated.
Any help will be appreciated.