Every Second Tuesday

This is exactly what I've been looking for. However, now I need to be able to do some kind of a lookup to be able to know exactly how many 'every other Sundays' in any given month for a period of years (biweekly mortgage payment program). Any ideas?

Great page written so even I can understand. I look forward to more examples of your skill.

Thank you very much

I had to write a calendar for a program for an event that ran every sixth day. I just had to test the result of mod(date,6)
to get what I wanted.

To fill cells with the date of the last day of the month:

In a spread-sheet I wrote, I had to do this to display dates for calibration of the instruments I look after.

In cells A1 and A2 (or other convenient location) enter the following -
=YEAR(TODAY()) and =MONTH(TODAY())

Then, in the cell which is to display the last day of the month, enter -
=DATE(A1, A2+1, 0).
(The formula is calculating the "0th day" of next month, which is of course the last day of this month).

To display the date of the last day of NEXT month, change A2+1 into A2+2, and so on.

@Mogens Kjær,
The present tip refers to the newer versions of Excel therefore I would suggest to use the EOMONTH Function - as illustrated in the linked picture:
http://screenpresso.com/=Ja6Pb
--------------------------
Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” MVP – Excel (2009-2016)
ISRAEL

To create a list consisting of the second Tuesdays of each month (not the same as every two weeks), use this formula in cell A3 after first inserting a starting Tuesday in cell A2:
=IF(AND(DAY(A2+28)>=8,DAY(A2+28)<=14),A2+28,A2+35)
Copy the formula down the column as far as needed. The second Tuesday of each month is either 28 or 35 days after the second Tuesday of the previous month.

To find the last day of the month for a date in cell B4, use this formula:
=EOMONTH(B4,0)

@Chris: If you put year in A2 and Month in B2, this will give you the second Tuesday of that month:
=DATE(A2,B2,CHOOSE(WEEKDAY(DATE(A2,B2,1),2),9,8,14,13,12,11,10))

Here's a UDF for finding the Mth occurrence of a day

Function MthOccurrenceoftheNthDayoftheKthMonthofYearY(M As Integer, N As Integer, K As Integer, Y As Integer) As Date
Dim First As Date
Dim NumDays As Integer

First = DateSerial(Y, K, 1)
NumDays = N - Weekday(First)
If NumDays < 0 Then NumDays = NumDays + 7
MthOccurrenceoftheNthDayoftheKthMonthofYearY = DateAdd("d", NumDays + (M - 1) * 7, First)
End Function

good technique...

This tip is misnamed! This tip should be called "Every Other Tuesday." The usage of the word "second" implies that there is a "first" and perhaps a "third" and/or more. These are words that are already most commonly applied to the weeks within a month. I suggest that we not confuse (or dilute) that usage. The phrase "every other Tuesday" is common usage and explicitly and uniquely applies to this tip. Why would you call it anything else?

And as an aside, as Excel date usage goes, your "every other Tuesday" problem is trivial compared to a real "every second Tuesday [of the month]" problem. You should take on that as a challenge!

To find the last day of the month, use DATE(YEAR(A4),MONTH(A4)+1,0).
To find the first day of the month, use
DATE(YEAR(A4),MONTH(A4)+1,1)

This is a useful tip.
What if you want to make a list of dates with the first or the last day of a month? Now the number og days are not longer same.