"Mike Metal" ha scritto nel messaggio


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)
----------------------------------------------------------------------------------------