Round to the First of the Month
Hello Excel masters! I am trying to figure out how to round to the first of the next month UNLESS the date entered in A1 is already the first of the month.
Example:
A1 = 6/2/2015 I need B1 to = 7/1/2015
A1 = 6/1/2015 I need B1 to = 6/1/2015
I know how to get the first part but I can't figure out the second. I'm hoping one of you can!
TIA!
Last edited by calinini; 03-12-2015 at 01:38 PM.
This works
=EOMONTH(A1,0)+NOT(DAY(A1)=1)
UPDATE: Oops! No it doesn't.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Try this instead
=IF(DAY(A1)=1,A1,EOMONTH(A1,0)+1)
nevermind, misunderstood request.
or
=EOMONTH(A1-1,0)+1
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
PERFECT! Thank you soooo much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks