Try this:

=TODAY()-WEEKDAY(TODAY(),3)+4

--
Biff
Microsoft Excel MVP


"deepika :excel help" wrote in
message ...
when iam in week mon-fri , teh date in a cell say J1 should show that
week's
friday date . for eg., when im in anyday between 18 and 22, that
paticular
cell shud show 22 -Feb-08 and when im anywhere bertween 25 and 29 it
should
show 29-Feb-08.
ithat cell shud automatically pick friday adte based on the date which we
r
in now.
could u pls help. im doing this for automation purpose..
is VBA req or wat can be done