# Display the first of the following month based on a date in previous cells

1. ## Display the first of the following month based on a date in previous cells

I would like to have the following month appear in a cell based on the previous cell.

So if one cell is 02/26/19, the next cell would be 03/01/19.

Thanks for any help with the formula.

Nick

2. ## Re: Display the first of the following month based on a date in previous cells

why would the next cell be 3/1 if the other cell is 2/26 (what happens to 2/27 and 2/28 for example)? Someone will need to know what logic you are using in order to create a formula for it.

3. ## Re: Display the first of the following month based on a date in previous cells

It’s actually just for helper cells, one would be a start date and I would have the remaining be the first of each month.

Thanks,
Nick

4. ## Re: Display the first of the following month based on a date in previous cells

so, whatever the date is in the one cell, you want the adjacent cell (next column over) to have the first date of the next month, is that correct? So for example if the date was 2/15/19 you'd want the next one to be 3/1/19?

5. ## Re: Display the first of the following month based on a date in previous cells

I got this to work.

=EOMONTH(A1,1)+1

6. ## Re: Display the first of the following month based on a date in previous cells

Nope, spoke too soon, that skips a month.

7. ## Re: Display the first of the following month based on a date in previous cells

ha ha, that is what I was going to recommend if post #4 was correct.

Oops, make it this way...
=EOMONTH(A1,0)+1
and you're there.

8. ## Re: Display the first of the following month based on a date in previous cells

Yes that is correct.

9. ## Re: Display the first of the following month based on a date in previous cells

Thanks, Sambo kid!

10. ## Re: Display the first of the following month based on a date in previous cells

you're welcome, glad I could help!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1