Showing Fridays of each month in a 4 week month and a five week month

**david_j_p** · 05-08-2013, 10:16 PM

I am trying to display the Fridays of each month for a financial year.

I have a worksheet that I made to show dates (Fridays) in Five columns for each month, and the fifth to show only if there is a fifth.
Even though this part works, the following months do not show correctly as it is not adding the actual days that exist in a month, by ignoring the 31st day of the month in the addition to the date in the prior cell.
So the following month is out by a day, and so on.

Any ideas for a solution???

Any help much appreciated, as I spent so much time looking for a solution!

**Lemice** · 05-08-2013, 10:40 PM

Hello,

I change your C8 on worksheet 1 to 6/8/12, and I see it is working fine. (June 8, 2012 is the first friday of June).
Similarly, if I change C8 on worksheet 1 to 7/6/12, I see it is working just fine also (July 6, 2012 is the first friday of July).

I also did a WEEKDAY on all of the day on your worksheet, and they are all Monday.

**david_j_p** · 05-08-2013, 11:03 PM

Yes! you are right about the Monday, I was a Whole month out! I am blind, need more sleep. Thanks a lot. The second sheet works perfectly now!

**protonLeah** · 05-08-2013, 11:03 PM

Have a look here:

**david_j_p** · 05-08-2013, 11:12 PM

Thanks for the help On the second sheet if you change the first day to an actual Friday, Not the Monday that I had, It works!
I just had the starting day wrong!

**daddylonglegs** · 05-09-2013, 06:27 AM

The formulas in the first sheet should be OK if you just change the formula for the 5th column.

For G8 you could simply check the day (of the month) - if it's < 8 then it's in the next month and you don't want it to display, i.e. this formula in G8 copied down

=IF(DAY(F8+7)<8,"",F8+7)