=TODAY()+13-WEEKDAY(TODAY())

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"deepika :excel help" wrote in message
...
| 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