Re: How to Find Weekend date

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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@xxxxxxxxxx> wrote in message
news:eY0aUbLUFHA.3532@xxxxxxxxxxxxxxxxxxxxxxx
> "Mike Metal" <mayankm@xxxxxxxxx>ha scritto nel messaggio
> xxWde.1234$Jz2.1000@xxxxxxxxxxxxxxxxxxxxxxxxxx
>
>> 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)
> ----------------------------------------------------------------------------------------
>
>


.

Relevant Pages