I want to construct a formula so that when one enters a date, then a certain respective number appears in reaction to date occurring within a certain temporal range.
Temporal Ranges include all dates respectively mentioned
02/01/2011 - 01/31/2012
Year to return: 2010
02/01/2012 - 01/31/2013
Year to return: 2011
02/01/2013 - 01/31/2014
Year to return: 2012
02/01/2014 - 01/31/2015
Year to return: 2013
02/01/2015 - 01/31/2016
Year to return: 2014
Try
=YEAR(A1-31)-1
I contemplated that if one entered a date such as 11/13/13, then in another cell, the year 2012 would manifest.
I refer to this parameter from earlier:
02/01/2013 - 01/31/2014
Year to return: 2012
Perhaps you entered Jonmo's formula incorrectly? It worked well for me, and I consider it very slick...
I1=YEAR(H1-31)-1
copied down
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I may have to reassess this situation. I will attempt to verify this situation. Your assistance, to all respondent members, stands acknowledged and I hereby express my gratitude.
You're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks