If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Friday
Typo correction...
GetFriday = "The most recent Friday was " & Date - lngN - 1 should read... GetFriday = "The most recent Friday was " & dteEntry - lngN - 1 Jim Cone |
#12
|
|||
|
|||
Friday
You posted a similar but different question elsewhere, involving
the last Friday of the month, or the previous Friday before the last day of the month, see http://www.mvps.org/dmcritchie/excel/datecalc.htm Actually Winston said the Friday before the last working day of the month which is a whole new ball of worms with networkdays and holidays. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Winston" wrote in message ... Hi How do I calculate the following problem If today does not equal friday then go back to last friday. Can anyone HELP? Regards Winston -- Winston ------------------------------------------------------------------------ Winston's Profile: http://www.excelforum.com/member.php...o&userid=28344 View this thread: http://www.excelforum.com/showthread...hreadid=479278 |
#13
|
|||
|
|||
Friday
Roger Govier When I copy and paste your formula it's got a error just ends up being text Regards Winston -- Winston ------------------------------------------------------------------------ Winston's Profile: http://www.excelforum.com/member.php...o&userid=28344 View this thread: http://www.excelforum.com/showthread...hreadid=479278 |
#14
|
|||
|
|||
Friday
Hi Winston,
FYI excelforum does not recognize threading, as your reply came out as a reply to me rather than Roger. There is a missing close paren after TODAY() it should be =TODAY()+CHOOSE(WEEKDAY(TODAY()),-2,-3,-4,-5,-6,0,-1) You can see what a thread really looks like here. http://google.com/groups?threadm=Win...rum-nospam.com --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Winston" wrote in message ... Roger Govier When I copy and paste your formula it's got a error just ends up being text Regards Winston -- Winston ------------------------------------------------------------------------ Winston's Profile: http://www.excelforum.com/member.php...o&userid=28344 View this thread: http://www.excelforum.com/showthread...hreadid=479278 |
#15
|
|||
|
|||
Friday
Hi Winston,
That other thread you started was actually in this same newsgroup http://groups.google.com/groups?thre...gp 13.phx.gbl Best to keep with the orginal thread rather than causing a dilution. |
#16
|
|||
|
|||
Friday
Hi all, I got enough problems with my project without losing our thread LOL Winston -- Winston ------------------------------------------------------------------------ Winston's Profile: http://www.excelforum.com/member.php...o&userid=28344 View this thread: http://www.excelforum.com/showthread...hreadid=479278 |
#17
|
|||
|
|||
Friday
Hi David & Winston
Thank you David for pointing out the error in my posting. Apologies Winston for the sloppiness in my typing. On this occasion, I didn't cut and paste from the formula I had proved worked in my workbook. I think David also posted in another thread =TODAY()-CHOOSE(WEEKDAY(TODAY()),2,3,4,5,6,0,1) Its amazing that one can't see that Adding negative numbers is the same as subtracting when you are in the midst of solving a problemvbg. Regards Roger Govier David McRitchie wrote: Hi Winston, FYI excelforum does not recognize threading, as your reply came out as a reply to me rather than Roger. There is a missing close paren after TODAY() it should be =TODAY()+CHOOSE(WEEKDAY(TODAY()),-2,-3,-4,-5,-6,0,-1) You can see what a thread really looks like here. http://google.com/groups?threadm=Win...rum-nospam.com --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Winston" wrote in message ... Roger Govier When I copy and paste your formula it's got a error just ends up being text Regards Winston -- Winston ------------------------------------------------------------------------ Winston's Profile: http://www.excelforum.com/member.php...o&userid=28344 View this thread: http://www.excelforum.com/showthread...hreadid=479278 |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find out first Friday every month | Ragdyer | General Discussion | 7 | September 2nd, 2005 12:59 AM |
Find out first Friday every month | noiseash | Worksheet Functions | 3 | September 1st, 2005 09:24 AM |
Date Calculations | Bruce | Worksheet Functions | 11 | May 19th, 2005 01:09 AM |
Join 2 Tables with query problem | ShyGuy | Running & Setting Up Queries | 3 | October 14th, 2004 04:24 AM |
Find 1st friday after a varible date | GitarJake | New Users | 3 | May 27th, 2004 07:34 AM |