LinkBack URL
About LinkBacks
Hi,
I would like to be able to have a formula which looks at a date in cell B2 and displays a date in cell B3 which is 12 months prior and takes account of leap years.
e.g.
Cell B2 = 1 March 2012
Cell B3 = 1 March 2011
Any help greatly appreciated.
Calculating a Previous Date
Hi,
I would like to be able to have a formula which looks at a date in cell B2 and displays a date in cell B3 which is 12 months prior and takes account of leap years.
e.g.
Cell B2 = 1 March 2012
Cell B3 = 1 March 2011
Any help greatly appreciated.
Last edited by dinonz1965; 10-10-2011 at 05:36 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks