Date Question

[giuls21]

Does anyone know a formula that could be dragged down to give pay check dates? I get paid on the 15th and end of each month (so could be 28th,29th, 30th or 31st). Instead of me manually typing in the date each time, I was curious if there was a good formula to make this automatic.

 

[Peter_SSs]

Try this formula copied down after entering the first date manually. If it produces an error, please advise what version of Excel you are using.

Excel Workbook
	A
1
2	15/01/11
3	31/01/11
4	15/02/11
5	28/02/11
6	15/03/11
7	31/03/11
8	15/04/11
9	30/04/11
Pay Dates

 

[Coryj5]

Is this what you are looking for? A formula to calculate the last day of the month constantly?
You have to put these in seprate cells, but you can hide them and only show the EOM formula. today() is in cell A1 in this example.

<TABLE style="WIDTH: 209pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=278><COLGROUP><COL style="WIDTH: 96pt" width=128><COL style="WIDTH: 113pt; mso-width-source: userset; mso-width-alt: 2742" width=150><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 96pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=20 width=128>=TODAY()</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 113pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl63 width=150></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=20>=DAY(A1)</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=20>=MONTH(A1)</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=20>=YEAR(A1)</TD><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" class=xl63>=EOMONTH(DATE($A$4,$A$3,$A$2),0)</TD></TR></TBODY></TABLE>

 

[Coryj5]

Peter... nice!

 

[giuls21]

Try this formula copied down after entering the first date manually. If it produces an error, please advise what version of Excel you are using.

Excel Workbook
	A
1
2	15/01/11
3	31/01/11
4	15/02/11
5	28/02/11
6	15/03/11
7	31/03/11
8	15/04/11
9	30/04/11
Pay Dates

Wow works perfect! Thank you so much!!!