N
noiseash
I have problem with writing the formula that copy the content of on
sheet to another first Friday every month, some second Friday ever
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 o
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
sheet to another first Friday every month, some second Friday ever
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 o
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