Bill Martin -- (Remove NOSPAM from address) wrote:
noiseash wrote:

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!




How about:

[ ] = =IF(AND(WEEKDAY(NOW())=1,DAY(NOW())<8),TRUE,FALSE)

Bill
-----------------

Actually, that checks for the first Sunday. As you've probably already
realized, it should be:

[ ] = IF(AND(WEEKDAY(NOW())=6,DAY(NOW())<8),TRUE,FALSE)

Bill