Hi,
i have attached a sheet here as demo = i'm looking for vba code/formula that if in Sheet 2 - A date is showing for current week than automatically Sheet 1 shows yes otherwise show no. This is not for a specific week, it's ongoing.
I wonder if someone can please guide me.
thanks
You could use this formula...
Formula:
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
THank you Guru
but that wouldn't pick up specifically for person "A" and that's what I'm looking for the help please.
see solution here
https://www.mrexcel.com/board/thread...a-yes.1128979/
=IF( SUMPRODUCT((Sheet1!A4:D599="ashina")*(Sheet1!E4:E599>=(INT((TODAY()-1)/7)*7+1))*(Sheet1!E4:E599<=(INT((TODAY()-1)/7)*7+7)))>0, "yes", "no")
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks