Formula to find Each Tuesday of the particular month i set in a separate cell

[dandeisel]

Hi,

Can someone help me figure out a formula that will calculate the date of each Tuesday of the month that I have in Cell A1?

For example. In Cell A1 I have the number 5 to represent the 5th month of the year (MAY) what formula should I put in the next 5 cells that will pull up the 1st Tuesday, 2nd Tuesday, 3rd Tuesday, 4th Tuesday and if applicable that month the 5th Tuesday?

Thanks for your help!

 

[steve the fish]

This formula will find the first tuesday:

=DATE(YEAR(TODAY()),$A$1,1+7*ROWS($A$1:A1))-WEEKDAY(DATE(YEAR(TODAY()),$A$1,5))

Drag down for subsequent tuesdays. If you want to return blank as you go into a seperate month you can use this:

=IF(MONTH(DATE(YEAR(TODAY()),$A$1,1+7*ROWS($A$1:A1))-WEEKDAY(DATE(YEAR(TODAY()),$A$1,5)))=$A$1,DATE(YEAR(TODAY()),$A$1,1+7*ROWS($A$1:A1))-WEEKDAY(DATE(YEAR(TODAY()),$A$1,5)),"")

 

[dandeisel]

Steve! Your awesome!!! Thank you so much. It worked perfectly. Quick question if you don't mind. If I wanted to find the Friday of the same formula what number do I need to change?

 

[steve the fish]

The 5 at the end to a 2 should do that.

 

[dandeisel]

Steve! it worked!. Thank you again. I really appreciate what you did for me.