Hello everyone!
As an example, in A1 I have this date, which is 13 June 2013.
A1: 13-06-2013
What formula would I need to show the first day of the month, based on that date in A1:
B1 should be: 01-06-2013
And how can I show the first day of the next month, based on A1:
B2 should be: 01-07-2013
Kind regards,
Marco
In B1:
=EOMONTH(A1,-1)+1
And in B2:
=EOMONTH(A1,0)+1
First answer:Second answer:
Please Login or Register to view this content.Second one doesn't work with december, not sure how to implement that.Please Login or Register to view this content.
Thank you both for the answers!
@RHCPgergo:
When I enter "20-12-2013" in A1, your second formula returns "1-1-2014", so it seems to be working.
@Andrew-R
It seems that your second answer has a problem with December. With the same in A1 as above, your formula returns "1-12-2013".
Kind regards and thank you!
Marco
I accidently double posted above post and I'm not sure if I can delete this post or not.
Last edited by Marco-Kun; 01-16-2013 at 11:29 AM. Reason: Double post.. ^_^
Wow, you're right it works. I just assumed it doesn't.
Haha alright! Thanks for your help!
Not in my copy of Excel it doesn't, and it's hard to see how it could.Originally Posted by Marco-Kun
@Andrew
Oops! I'm sorry Andrew! I didn't save my test file yesterday to test both your formula so I don't know what went wrong. But indeed, yours work perfectly fine as well.
Yesterday my test file looked like this:
A1: 20-12-2013
These containing your fomula
B1: 1-12-2013
B2: 1-12-2013
These containing RHCPgergo's formula
C1: 1-12-2013
C2: 1-1-2014
I probably inserted the same formula from you in B2 as I did in B1 or some stupid stuff like that.
Sorry again!
Kind regards,
Marco
Hi,
why second answer doesn't work?
kiwikloud welcome to the forum
1st, it seems the 2nd formula did work.
2nd, Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sry, I didn't know the rules.
Last edited by kiwikloud; 05-11-2016 at 01:40 AM.
Not a problem
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks