Changing a start dat

[mort1703]

Hi

I am not sure if this is possible, but here goes.

I have a date field containing a date within a month ie. 27 May 2018

Is it possible to move the date to 1st of the following month

Example 1
F25 = 27 May 2018
G25 = 01 June 2018

Example 2

F25 = 12 May 2018
G25 = 01 June 2018

Example 3

F25 = 27 June 2018
G25 = 01 July 2018​

Example 4

F25 = 12 July 2018
G25 = 01 August 2018
​

​

Example 5

F25 =

01 August 2018​

​

<strike></strike>

G25 = 01 August 2018​

 

[MARK858]

Maybe...

=EOMONTH(F25,0)+1

 

[jtakw]

Hi,

If the original date is already the 1st of the month and you want it to stay the same (as in your Example 5), then just a slight modification to Mark's formula:

Book1
	F	G
25	27-May-18	1-Jun-18
26	12-May-18	1-Jun-18
27	27-Jun-18	1-Jul-18
28	12-Jul-18	1-Aug-18
29	1-Aug-18	1-Aug-18
Sheet12

Cell Formulas
Range	Formula
G25	=EOMONTH(F25-1,0)+1