Friday date of next week..

  • Thread starter deepika :excel help
  • Start date
D

deepika :excel help

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
 
N

Niek Otten

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| 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
 
R

Ron Rosenfeld

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
Click to expand...

It depends, in part, on when you want the week to change.

If your week ends on Friday, so that Saturday Feb 16th should return the 29th,
then:

=A1+14-WEEKDAY(A1+1)

If your week ends on Saturday:

=A1+13-WEEKDAY(A1)

And if your week ends on Sunday:

=A1+12-WEEKDAY(A1-1)
--ron
 
Top