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

Try this:

=TODAY()-WEEKDAY(TODAY(),3)+4

--
Biff
Microsoft Excel MVP


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

i tried it worked for weekdays yes.
when im on a saturday say(16 th feb) it has to show 22nd feb (friday) but it
shows the prev friday(15 feb)..
any day after a friday it shud show the next friday.
Also is it meaningful to havea code for this inside a macro.. teh reason is
taht whenever i open that cell should giveme friday date

"deepika :excel help" wrote:

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

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

With the weekday date in H1, put this in J1 =H1+(6-WEEKDAY(H1))
It will add the number of days til friday to the date in H1.

Here is the results for the week of February 18th, 2008

Date Fridays date
Sun Feb-17 Fri Feb-22
Mon Feb-18 Fri Feb-22
Tue Feb-19 Fri Feb-22
Wed Feb-20 Fri Feb-22
Thu Feb-21 Fri Feb-22
Fri Feb-22 Fri Feb-22
Sat Feb-23 Fri Feb-22
Sun Feb-24 Fri Feb-29

Try:

=TODAY()-WEEKDAY(TODAY()+1,1)+7

Also is it meaningful to havea code for this inside a macro.. teh reason
is
taht whenever i open that cell should giveme friday date

Would you care to restate that I am unclear as to your meaning.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"deepika :excel help" wrote in
message ...
i tried it worked for weekdays yes.
when im on a saturday say(16 th feb) it has to show 22nd feb (friday) but
it
shows the prev friday(15 feb)..
any day after a friday it shud show the next friday.
Also is it meaningful to havea code for this inside a macro.. teh reason
is
taht whenever i open that cell should giveme friday date

"deepika :excel help" wrote:

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

On Mon, 18 Feb 2008 05:58:03 -0800, deepika :excel help
wrote:

i tried it worked for weekdays yes.
when im on a saturday say(16 th feb) it has to show 22nd feb (friday) but it
shows the prev friday(15 feb)..
any day after a friday it shud show the next friday.
Also is it meaningful to havea code for this inside a macro.. teh reason is
taht whenever i open that cell should giveme friday date


=A1+7-(WEEKDAY(A1+1))

or substitute TODAY() for A1 in the formula.


--ron