Results 1 to 6 of 6

Round to the First of the Month

Threaded View

  1. #1
    Registered User
    Join Date
    03-12-2015
    Location
    Los Angeles, CA
    MS-Off Ver
    2010
    Posts
    2

    Question 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.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 12-06-2014, 01:58 PM
  2. [SOLVED] How to round to nearest .01 and round down if thousands place is .005
    By dredre609 in forum Excel General
    Replies: 5
    Last Post: 09-29-2014, 11:47 AM
  3. Round up month
    By Edfermo in forum Excel General
    Replies: 2
    Last Post: 11-30-2005, 04:15 PM
  4. Round date to first of month
    By Dominic in forum Excel General
    Replies: 3
    Last Post: 07-14-2005, 07:05 PM
  5. How do I ROUND() round off decimals of a column dataset?
    By Højrup in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-12-2005, 07:06 AM

Tags for this Thread

Bookmarks

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