Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Find out first Friday every month
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=401019 |
#2
|
|||
|
|||
See if this helps to get you started ... lawdoggy had a similar
problem. http://groups.google.com/group/micro...8131713933c75e |
#3
|
|||
|
|||
You have a couple of answers in the misc. group.
Please don't multi-post! -- Regards, 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=401019 |
#4
|
|||
|
|||
=IF(TODAY()==DATE(YEAR(TODAY()),MONTH(TODAY()),1+7 )-WEEKDAY(DATE(YEAR(TODAY(
)),MONTH(TODAY()),2)),"Sheet1!A1","") -- HTH RP (remove nothere from the email address if mailing direct) "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=401019 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find out first Friday every month | Excel Discussion (Misc queries) | |||
HOW TO FIND DIFF. BETW. 2 DATES, IT SHOULD BE IN YRS, MONTH & DAY | Excel Worksheet Functions | |||
3rd friday in month | Excel Worksheet Functions | |||
Date Calculations | Excel Worksheet Functions | |||
Finding Friday | Excel Discussion (Misc queries) |