Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
noiseash
 
Posts: n/a
Default 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   Report Post  
Blue Hornet
 
Posts: n/a
Default

See if this helps to get you started ... lawdoggy had a similar
problem.

http://groups.google.com/group/micro...8131713933c75e

  #3   Report Post  
Ragdyer
 
Posts: n/a
Default

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   Report Post  
Bob Phillips
 
Posts: n/a
Default

=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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find out first Friday every month Ragdyer Excel Discussion (Misc queries) 7 September 2nd 05 12:59 AM
HOW TO FIND DIFF. BETW. 2 DATES, IT SHOULD BE IN YRS, MONTH & DAY Mushtaq Ahmed .T Excel Worksheet Functions 3 August 25th 05 10:05 AM
3rd friday in month [email protected] Excel Worksheet Functions 17 June 11th 05 08:47 PM
Date Calculations Bruce Excel Worksheet Functions 11 May 19th 05 01:09 AM
Finding Friday Arlen Excel Discussion (Misc queries) 1 January 23rd 05 06:08 AM


All times are GMT +1. The time now is 07:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"