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