Date Formula - 1st,2nd & 3rd Sundays of each month

lsmft · 11-01-2007, 05:54 PM

I'd like to set up a sheet so that Column "A" would reflect the first Sundays' offerings of each month, Column "B" the second Sundays, "C" 3rd Sunday, etc.
Cell "A-2" = 1st Sunday of Jan.
Cell "B-2" = 2nd Sunday of Jan.
Cell "A-3" = 1st Sunday of Feb. etc.
Can this be done by formula or do I just need to do it manually.
Thank you

**VBA Noob** · 11-01-2007, 06:11 PM

Assumes months in Col A

Try

=DATE(YEAR($A1),MONTH($A1),1)+MOD(8-WEEKDAY(DATE(YEAR($A1),MONTH($A1),1)),7)+INT(COLUMN(A1)-1)*7

or does this link help

http://www.excelforum.com/showthread.php?t=616380

VBA Noob

lsmft · 11-01-2007, 06:58 PM

Having some problems with it.
1) should the whole sheet be formatted for date or for numbers?
2) I'll be posting money amounts in the appropriate cells as the day comes up.
3) Could be I'm not sure how to ask what I want or if what I want is what I need.
Thanks anyway

**VBA Noob** · 11-01-2007, 07:04 PM

See example

VBA Noob

lsmft · 11-01-2007, 07:26 PM

Thank you, I can work with this.
This is THE answer I needed. All I have to do for the 5 Sunday weeks is click and drag and even I know how to do that.
Thanks again for the help and patience.

**VBA Noob** · 11-01-2007, 07:31 PM

Good to hear.

Can I remind you to use more descriptive titles in future to help make the site more searchable

VBA Noob

**daddylonglegs** · 11-01-2007, 07:49 PM

This way will show 4 Sundays or 5 as appropriate - change year in B1 as required

lsmft · 11-02-2007, 05:47 AM

Originally Posted by daddylonglegs

This way will show 4 Sundays or 5 as appropriate - change year in B1 as required

Thank you,
This will be a big help for me too.
I do appreciate the help offered via this website as it has greatly benefited me todate. I even look over other's posts to see if I may learn from them.
LOL

)