How to Find Weekend date

Hello All,

I need a formual or function to find weekend (last Friday, or any Friday's)
date in Excel.

Thanks in advance.

Mike

"Mike Metal" <mayankm@gmail.com>ha scritto nel messaggio
xxWde.1234$Jz2.1000@newssvr19.news.prodigy.com

> Hello All,
>
> I need a formual or function to find weekend (last Friday, or any
> Friday's) date in Excel.

You can use this formula:

=IF(WEEKDAY(your date)=6,condition if true,condition if false).


--
Hoping to be helpful... :-)

Regards

Franz

----------------------------------------------------------------------------------------
To reply translate from italian InVento (no capital letters)
----------------------------------------------------------------------------------------

Thanks Franz.

This gives the condition to be true if day=Friday (6). That is not what I
need.

I want to ab able to give the date of the last Friday or this Friday. I do
remember that this was in microsoft's knowledgebase, several years back! I
am unable to search for it.

I hope some one can get this for me.

Thanks in advance.

Mike
"Franz" <fra68ve@InVento.it> wrote in message
news:eY0aUbLUFHA.3532@TK2MSFTNGP09.phx.gbl...
> "Mike Metal" <mayankm@gmail.com>ha scritto nel messaggio
> xxWde.1234$Jz2.1000@newssvr19.news.prodigy.com
>
>> Hello All,
>>
>> I need a formual or function to find weekend (last Friday, or any
>> Friday's) date in Excel.
>
> You can use this formula:
>
> =IF(WEEKDAY(your date)=6,condition if true,condition if false).
>
>
> --
> Hoping to be helpful... :-)
>
> Regards
>
> Franz
>
> ----------------------------------------------------------------------------------------
> To reply translate from italian InVento (no capital letters)
> ----------------------------------------------------------------------------------------
>
>

See if one of the functions in the "Days Of The Week And Month" section
of this page helps:

http://cpearson.com/excel/DateTimeWS.htm

In article <NEfee.1516$6E.790@newssvr33.news.prodigy.com>,
"Mike Metal" <mayankm@gmail.com> wrote:

> This gives the condition to be true if day=Friday (6). That is not what I
> need.
>
> I want to ab able to give the date of the last Friday or this Friday. I do
> remember that this was in microsoft's knowledgebase, several years back! I
> am unable to search for it.