Reminder on every other Friday

dennisli

Well-known Member
Joined
Feb 20, 2004
Messages
1,070
Good morning, everyone,
Every other Friday, I need to submit my biweekly work hour sheet to manager. For example, as 12/21/2007 is Friday and pay day, I need to submit my sheet. Next time is two weeks later, 1/4/08, and on.
12/21/07 is the first event.
I want to create a conditional format, or workbook events, or worksheet events to remind me on that Friday when I open that book or activate that sheet.
Any idea will be welcomed.
Thanks lot.
Dennis
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
This might be a stupid question, but do you use Outlook? You can set reminders up in there very easily.
 
Upvote 0
Would it not be easier to set up a recurring Outlook task (assuming you use Outlook) to give you the reminder? That way, even if you forget to open the workbook altogether, you'd still get the reminder...
 
Upvote 0
thanks lot. I do not use OutLook.
I agree with Andrew's solution and I am thinking to convert this one to a workbook before_open events.
 
Upvote 0
I just wrote workbook_open events to remind me when I open this workbook. But it gets a problem with Today().
What shoul I do?
thanks lot.
Dennis

Code:
Private Sub Workbook_Open()
  Dim BegFriday As Date
  Dim MyFriday As Date
  Dim ModFriday As Integer
    
    BegFriday = "12/21/2007"
    MyFriday = TODAY() - BegFriday
    ModFriday = MyFriday Mod 14
  
  If ModFriday = 0 Then
    MsgBox "Today is Friday. Submit your time sheet"
  End If
  
End Sub
 
Upvote 0
You might try this:
In ThisWorkbook paste

Private Sub Workbook_Open()

If XXX Then MsgBox "Your Message Here"

End Sub
Function XXX() As Boolean
XXX = ((Date - #12/21/2007#) Mod 14) = 0
End Function


*Gee, I was late getting of the pot.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,207
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top