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