Maybe

=A1+(11-WEEKDAY(A1,2)+1)

With your date in A1

Mike

"deepika :excel help" wrote:

how do i bring in tht next week friday's date in a particular cell .
say for eg., when im anywhere between 11th and 15th feb i should get date
22feb in that cell and so on.....
so at any point in a week i should get only the friday date of next week
pls help