friday date

[deepika :excel help]

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

 

[T. Valko]

Try this:

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

 

[deepika :excel help]

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

 

[andy]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Ron Rosenfeld]

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