Hello Group,

The formula given to me by daddylonglegs works fine but I want to add to the
equation:

=IF(A2="M",TEXT(DATE(0,MONTH(D2)+(D2>=DATE(YEAR(D2),MONTH(D2),22)-WEEKDAY(DATE(YEAR(D2),MONTH(D2),4))),1),"mmmm"),"")I want to also add:IF(A2="N",D2,) Cell D2 has a date. So, if cell A2="N" I want to use thedate in D2 and change it to "mmm"in cell E2. And finally, I want to add thesame formula only using "O".When I try to add to the top formula, I get #VALUE!Please help with this"daddylonglegs" <daddylonglegs.29yzin_1151259001.7141@excelforum-nospam.com>wrote in messagenews:daddylonglegs.29yzin_1151259001.7141@excelforum-nospam.com...>> Digital2k Wrote:>> How can I create a formula that will do this: = IF cell A2 ="m" and if>> cell>> D2 is between 5/19/06 and 6/20/06 than cell E2 ="June" + if A2 = "m">> and D2>> is between 6/21/06 and 7/18/06 than E2 = "July" and so on?>> This is the formula I used:>>=AND(A2="m")*IF(D2=38854:38888,"June")+AND(A2="m")*IF(D2=38889:38916,"July")>> I either get an #Value!, or some other error. Please help!>> Try this formula in E2>>=IF(A2="M",TEXT(DATE(0,MONTH(D2)+(D2>=DATE(YEAR(D2),MONTH(D2),22)-WEEKDAY(DATE(YEAR(D2),MONTH(D2),4))),1),"mmmm"),"")>>> --> daddylonglegs> ------------------------------------------------------------------------> daddylonglegs's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=30486> View this thread: http://www.excelforum.com/showthread.php?threadid=554930>