LinkBack URL
About LinkBacks
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
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
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.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
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
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?
I got this to work.
=EOMONTH(A1,1)+1
Nope, spoke too soon, that skips a month.
ha ha, that is what I was going to recommend if post #4 was correct.
Glad you got it yourself.
Oops, make it this way...
=EOMONTH(A1,0)+1
and you're there.
Yes that is correct.
Thanks, Sambo kid!
you're welcome, glad I could help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks