View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt.Russett Matt.Russett is offline
external usenet poster
 
Posts: 14
Default Return the Date of a certain Day Each Month

I have data that needs to be updated in a system on certain days in a
month as required by contract.

Here is an example of something that I am currently doing that is
similar to my question

I have something that needs to be updated every Tuesday
In cell A1 there is the =Today() function. Today is Wednesday 2/28/07
Cell B2 "Current Weekday" = Weekday(A1) = 4
Cell C2 "Desired Weekday" = 3 (for Tuesday)
Cell D2 "Coefficient" = C2-B2 = -1
So.. the Update date would be A1+D2 = (2/28/07 + -1) = 2/27/07
(Tuesday of current week)

Now my question is what if I have something that needs to be updated
on the Second Monday of every month?

How can I set up a formula that will return the Date of the 2nd Monday
for the current month (based on =Today())

Thank you!