Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a formula that will return only the month from a date? | Excel Discussion (Misc queries) | |||
Return Month & Year of Date Value | Excel Discussion (Misc queries) | |||
return month from a date | Excel Discussion (Misc queries) | |||
Auto return month as text date | Excel Discussion (Misc queries) | |||
In Excel How do I return the Month for a specific date | Excel Discussion (Misc queries) |