I have a formula that will checks and shows the months within a certain range. However when I look at the second month (cell C3), it return 28 instead of 8.
I've tried it all from converting the date to the format of the cell, but it seems not to work. Any tips?
Why would you expect 8, when the month number is 9?
a simple =month(cell-ref) should work.
If that is not the case, please explain what you are doing.
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
I would expect 8 because it should show 7, 8 and 9 (all months between the 2 dates). And the 3rd cell (c4) should then show 9.
If the last date is e.g. 1-12-2018, it should show 7, 8, 9, 10, 11 and 12 below each other (if the formula was copied further)
Can you show what you expect, in your file please.
You cannot use EDATE with cell C2, which just contains a number. Try this in C3:
=IFERROR(MONTH(IF(EDATE(A2,1)>A3,"",(EDATE(A2,1)))),"")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi AliGW; that was exactly what I was looking for; thanks!
You're welcome!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks