Sorry ! ! !
Tested this formula and forgot to change the date back before posting.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" wrote in message
...
Try this:
=IF(TODAY()=TODAY()-DAY(TODAY())-WEEKDAY(TODAY()-DAY(TODAY())-2)+11,Sheet1!A
1,"")
--
HTH,
RD
--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"noiseash" wrote
in
message ...
I have problem with writing the formula that copy the content of one
sheet to another first Friday every month, some second Friday every
month, third, fourth....etc.
What I want is, eg, in cell "A1" of sheet2
if (today=first Friday, sheet1!A1,"")
i don't know how to let the system judge if today is a first Friday of
this month or not. I write a formula like this:
if(weekday(today())=5,sheet1!A1,"")
But this only works for every Friday, not for First/Second...Fridays
Any help will be appreciated. Thank you!
--
noiseash
------------------------------------------------------------------------
noiseash's Profile:
http://www.excelforum.com/member.php...o&userid=26629
View this thread:
http://www.excelforum.com/showthread...hreadid=401020