Help Regarding Date Function / Formulas

[ddayf50]

For the past few days I've been trying to set up an Excel Sheet in order to help facilitate a "small" new project at work.
In short what I am having difficulties with is setting up a formula that will populates only Mondays. Heres a little summary of the project.
We are mailing out weekly Thank You Cards for new sign up and printing Labels with clients address on mondays. I would like to have an excel sheet in order to keep track. What I had in mind was setting up 1 column with all of the Mondays, a second column with all of the Sundays (so I have the start date and end date of that week in order to print out labels, another column for printed labels and last column for Mailed Out.

Our week begins on Monday through Sunday, therefore I would like to know how can I create a formula that would generate the date of only monday.

Start date was June 01, 2014.

Can someone guide me through on how to work with a day formula or week.
Thank you.

[Tony Valko]

Not sure what you're asking.

If you want the dates for every Monday...

Manually enter the 1st Monday date in some cell, say A2.

A2 = 9/8/2014

Then, enter this formula in A3:

=A2+7

Copy down as needed.

Then, if you want the Sunday dates in column B, enter this formula in B2 and copy down as needed:

=A2+6

Data Range

	A	B
1	Week Start	Week End
2	9/8/2014	9/14/2014
3	9/15/2014	9/21/2014
4	9/22/2014	9/28/2014
5	9/29/2014	10/5/2014
6	10/6/2014	10/12/2014
7	10/13/2014	10/19/2014
8	10/20/2014	10/26/2014
9	10/27/2014	11/2/2014
10	11/3/2014	11/9/2014

[ddayf50]

Sry if I made it sound complicated, however you did answer my question.

For some reason I assumed that the formula =A2+7 was not compatible with dates. I kept trying with different formulas with =date...

Sometime keeping it simple is the solution.

Thank a lot.

[Tony Valko]

In Excel dates are really just numbers formatted to look like dates. These numbers are commonly referred to as the date serial number. The date serial number is the count of days starting from a base date. In Windows Excel the default base date is January 1, 1900. So, January 1, 1900 is date serial number 1.

Jan 1 1900 = date serial number 1
Jan 2 1900 = date serial number 2
Jan 3 1900 = date serial number 3
Jan 4 1900 = date serial number 4
Jan 5 1900 = date serial number 5
etc
etc
Jan 1 1975 = date serial number 27395
Jan 1 2000 = date serial number 36526
Jan 1 2014 = date serial number 41640

You can see the date serial number by entering some date in a cell and then changing that cells format to General or Number.

This makes it possible to do math operations on dates such as =A2+7.

Thanks for the feedback!

[ddayf50]

Thanx a lot Tony, Im new to this whole Excel World.

I'm glad I was able to find a forum like this, were knowledgeable people are here to help others.

Once again, thanx a lot. (Ill probably have more questions in the near future) lol

[Tony Valko]

You're welcome!