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 (

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!

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!

## Comment