Date Formula

[esgca2010]

Hello,

I would like to create a formula that works from the first date entered into a cell.

Scenario:

1st date is entered by the user. In another column, I would like the following month but it should start on the 1st.

Example:

User Enters the 1st date in the first column. The second and third column has a formula based on the date of the first column that displays the 1st of the month
3/09/18 - 4-01-18 - 5-01-18
3/13/18 - 4-01-18 - 5-01-18
3/19/18 - 4-01-18 - 5-01-18

I truly appreciate your support.

Thank you,

Elaine

 

[Joe4]

Let's say that the first entry is in cell A2

Then in cell B2, enter the formula:

=DATE(YEAR(A2),MONTH(A2)+[COLOR=#ff0000][B]1[/B][/COLOR],1)

And in C2, just use:

=DATE(YEAR(A2),MONTH(A2)+[COLOR=#ff0000][B]2[/B][/COLOR],1)

(you can see the pattern)

 

[jtakw]

Hi,

How about:

Book1
	A	B	C	D	E
1	3/9/2018	4/1/2018	5/1/2018	6/1/2018	7/1/2018
2	3/13/2018	4/1/2018	5/1/2018	6/1/2018	7/1/2018
3	3/19/2018	4/1/2018	5/1/2018	6/1/2018	7/1/2018
Sheet72

Cell Formulas
Range	Formula
B1	=EOMONTH(A1,0)+1

B1 formula copied down and across as far as needed.

 

[MARZIOTULLIO]

b1=EOMONTH(A1,0)+1 copy down and across

 

[esgca2010]

Thank you!!!

You are the BEST!!!

Hello,

I would like to create a formula that works from the first date entered into a cell.

Scenario:

1st date is entered by the user. In another column, I would like the following month but it should start on the 1st.

Example:

User Enters the 1st date in the first column. The second and third column has a formula based on the date of the first column that displays the 1st of the month
3/09/18 - 4-01-18 - 5-01-18
3/13/18 - 4-01-18 - 5-01-18
3/19/18 - 4-01-18 - 5-01-18

I truly appreciate your support.

Thank you,

Elaine

 

[jtakw]

You're welcome, glad we can help.