3rd friday in month

Hi -
I have a cloumn with dates. what i need is that the function will
plot 1 if the certain date is the third friday in the relative month
and 0 if not.

How can I do that ?

I searched the net - found close subjects but not exactly this.

Thanks

Hi,

> I have a cloumn with dates. what i need is that the function will
> plot 1 if the certain date is the third friday in the relative month
> and 0 if not.


hmmmm....

is the third friday not the only friday between 15th and 21st?

arno

> is the third friday not the only friday between 15th and 21st?

=IF(AND(DAY(a1)>=15,day(a1)<=21,weekday(a1)=6),"3rd friday","ohh")

daddldo

arno

This clever Daniel M formula will always return the date (based on another
date) the third Friday, this assumes the date is in A1, adapt accordingly

=DATE(YEAR(A1),MONTH(A1),1+7*3)-WEEKDAY(DATE(YEAR(A1),MONTH(A1),8-6))

so if you have dates in A1:A50 and want to check them, this formula will
return TRUE if third Friday

=A1=DATE(YEAR(A1),MONTH(A1),1+7*3)-WEEKDAY(DATE(YEAR(A1),MONTH(A1),8-6))


that way you can copy the formula and it will return TRUE or FALSE


Regards,

Peo Sjoblom

"ramot06@yahoo.com" wrote:

> Hi -
> I have a cloumn with dates. what i need is that the function will
> plot 1 if the certain date is the third friday in the relative month
> and 0 if not.
>
> How can I do that ?
>
> I searched the net - found close subjects but not exactly this.
>
> Thanks
>
>

Based on Arno's response, you could use:

=(DAY(A1)>=15)*(DAY(A1)<=21)*(WEEKDAY(A1)=6)

HTH
Jason
Atlanta, GA

"arno" wrote:

> Hi,
>
> > I have a cloumn with dates. what i need is that the function will
> > plot 1 if the certain date is the third friday in the relative month
> > and 0 if not.
>
>
> hmmmm....
>
> is the third friday not the only friday between 15th and 21st?
>
> arno
>

I assume that if the data starts from A2 - the formula need to be
changed.
Not only the cell refference.

I tried it with changing to A2 and it gave me wrong result.

If i want it have 1 if true or 0 if false , is it possible or
just doing it in a different column ?

Thanks

sorry. it works good. but still what about 1 or 0 ?

Hi

=IF(AND(WEEKDAY(D5,2)=5,DAY(D5)>14,DAY(D5)<=21),TRUE,"")

Date in D5
This example will return True

Tip : See this Add-in if you want to insert this formula in your data table
http://www.rondebruin.nl/datarefiner.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


<ramot06@yahoo.com> wrote in message news:1118242583.043283.319060@g44g2000cwa.googlegroups.com...
> Hi -
> I have a cloumn with dates. what i need is that the function will
> plot 1 if the certain date is the third friday in the relative month
> and 0 if not.
>
> How can I do that ?
>
> I searched the net - found close subjects but not exactly this.
>
> Thanks
>

You realize that you must have a date in A2, not text representation of a date

=--(A2=DATE(YEAR(A2),MONTH(A2),1+7*3)-WEEKDAY(DATE(YEAR(A2),MONTH(A2),8-6)))

the above will work for A2 and return 1 or 0 for TRUE or FALSE

Regards,

Peo Sjoblom

"ramot06@yahoo.com" wrote:

> I assume that if the data starts from A2 - the formula need to be
> changed.
> Not only the cell refference.
>
> I tried it with changing to A2 and it gave me wrong result.
>
> If i want it have 1 if true or 0 if false , is it possible or
> just doing it in a different column ?
>
> Thanks
>
>