Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Friday date of next week..
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Friday date of next week..
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Friday date of next week..
=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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Friday date of next week..
On Wed, 13 Feb 2008 04:14:02 -0800, 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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Week Ended Friday | Excel Worksheet Functions | |||
How do I get the date for the 2nd friday of each month? | Excel Worksheet Functions | |||
Finding Friday in week number | New Users to Excel | |||
the date always friday | New Users to Excel | |||
I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) |