In cell A1 I have a date. I want a formula in another cell, say A2, that will show the 12th of the month before the date in A1.
For example, date is A1 is 28/2/09 (UK format), I want A2 to show 12/2/09.
Any ideas?
Thanks in advance for any help.
In cell A1 I have a date. I want a formula in another cell, say A2, that will show the 12th of the month before the date in A1.
For example, date is A1 is 28/2/09 (UK format), I want A2 to show 12/2/09.
Any ideas?
Thanks in advance for any help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks