| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
Sub iffriday()
c = Weekday(ActiveCell) If c = 6 And c >= 2 And c <= 10 Then MsgBox "ok" End Sub -- Don Guillett SalesAid Software (E-Mail Removed) "Aaron" <(E-Mail Removed)> wrote in message news  E66160C-A6EA-4030-BD9B-(E-Mail Removed)...>I am looking for code that does the following > Looks at active cell > Checks to see if the date value is a Friday date and if it is within 4 > days > of todays date. If so Varible x = "OK" > > Thanks, > Aaron |
|
|
|
|
|||
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| if date field not null or >0 check check box | JK | Microsoft Access VBA Modules | 4 | 28th Jan 2009 03:44 PM |
| Calculate a date (from start date) when check Box is activated | Oliver | Microsoft Access Forms | 2 | 18th May 2008 01:42 PM |
| Date question, check if date is before today | =?Utf-8?B?aVRhbmFz?= | Microsoft Access | 6 | 25th Mar 2006 03:26 AM |
| Change text to date and check against date in cell | =?Utf-8?B?Ulc=?= | Microsoft Excel Programming | 3 | 2nd Feb 2006 03:29 PM |
| ERROR check if a date set entered violates a previous date set | buzz | Microsoft Excel Misc | 1 | 21st Jun 2004 09:01 PM |
