Hello Ahmet,
Please try this formula,
=IF(MOD((A1-1),12)=0,12,MOD((A1-1),12)) where A1 is the active cell.
Regards,
Rajesh Kunder
On Thu, Jun 18, 2009 at 4:56 PM, Ahmet Yalcin <ahmetyalc...@gmail.com>wrote:
> Hello You Helpful People :)
>
> My question today is:
>
> For example I use vlookup to get a month "4" (April) from a database. At
> this report sheet I also want to show the previous 4 months. What I do here
> is subtract 1 from April, to find March and subtract 2 to find February,
> etc.. How can I form my formula that when the month reaches 1 (January) and
> when I subtract 1 it should give me 12 instead of 0 and 2008 instead of
> 2009. Or what is the way of doing this?
>
> Thank you in advance once again
>
> Regards
>
> Ahmet
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
