How can I create a formla using date ranges

Hello,

=IF(A1="m",TEXT(DATE(YEAR(D1),MONTH(D1)+1,DAY(D1)-20),"MMM");"something
else")

HTH,
Bernd

Thank you very much for this formula. It works perfect for June. But as I
use August, September and later, It does not change the month on the third
Wednesday of the month. This is the closes as anyone has come to making this
happen. if anyone can help me I would greatly appreciated.

Once again when I sell a product I have an
>>> expected date that I think it will get approved and get paid. One of
>>> the products, product "M" must get paid before the third Wednesday
>>> of the month if not then it will go the following month.
>>>
>>> I want to create a spreadsheet that will automatically make the
>>> adjustment by changing the month paid if the product is product "m"
>>> and the expected date paid is after the third Wednesday of the
>>> month. How can I create a formula that will do this? please help
>>> and thank you in advance.

<bplumhoff@gmail.com> wrote in message
news:1151134627.700847.130200@m73g2000cwd.googlegroups.com...
> Hello,
>
> =IF(A1="m",TEXT(DATE(YEAR(D1),MONTH(D1)+1,DAY(D1)-20),"MMM");"something
> else")
>
> HTH,
> Bernd
>

hi, I setup an very long formula to calculate it, see whether is good for
you.
=IF(A2="m",IF(D2<=EOMONTH(D2,-1)+21-IF(WEEKDAY(EOMONTH(D2,-1)+19,2)>=3,(WEEKDAY(EOMONTH(D2,-1)+21,2)-2),(WEEKDAY(EOMONTH(D2,-1)+21,2)+5)),MONTH(D2),MONTH(D2)+1),"UNKNOWN")


"Digital2k" <digital2k@adelphia.net> wrote in message
news:eNednT_zF7wNBgPZnZ2dnUVZ_qmdnZ2d@adelphia.com...
> Thank you very much for this formula. It works perfect for June. But as I
> use August, September and later, It does not change the month on the third
> Wednesday of the month. This is the closes as anyone has come to making
> this happen. if anyone can help me I would greatly appreciated.
>
> Once again when I sell a product I have an
>>>> expected date that I think it will get approved and get paid. One of
>>>> the products, product "M" must get paid before the third Wednesday
>>>> of the month if not then it will go the following month.
>>>>
>>>> I want to create a spreadsheet that will automatically make the
>>>> adjustment by changing the month paid if the product is product "m"
>>>> and the expected date paid is after the third Wednesday of the
>>>> month. How can I create a formula that will do this? please help
>>>> and thank you in advance.
>
> <bplumhoff@gmail.com> wrote in message
> news:1151134627.700847.130200@m73g2000cwd.googlegroups.com...
>> Hello,
>>
>> =IF(A1="m",TEXT(DATE(YEAR(D1),MONTH(D1)+1,DAY(D1)-20),"MMM");"something
>> else")
>>
>> HTH,
>> Bernd
>>
>
>