I have an input cell in which i enter the current month and would like a formula to calculate the previous month based on my current month input cell.
I've tried the "=current month input cell - 1" but this doesn't work :P
The TODAY & NOW functions are no good here i would think as the current date differs from the actual date often by a couple of months.
Bookmarks