+ Reply to Thread
Results 1 to 3 of 3

IF Formula showing date in cell above +1 day only if within month of date in another cell

Hybrid View

  1. #1
    Registered User
    Join Date
    01-12-2015
    Location
    Washington DC
    MS-Off Ver
    2013
    Posts
    3

    IF Formula showing date in cell above +1 day only if within month of date in another cell

    Cell A1 contains the date 2/28/15

    Cell B3 contains the formula =DATE(YEAR(B4),MONTH(B4),1) - RESULT 03/01/15
    Cell B4 contains the formula =B3+1 - RESULT 03/02/15
    Cell B5 contains the formula =B4+1, etc... - RESULT 03/03/15

    When I get to the cell where the date changes months to March (03/01/15), I want the cell to remain blank.

    The idea is that each month the only cell that will be manually changed is cell A1, (that cell must be the last day of the month, because it is used in other parts of the workbook). and the dates listed in column B will only be for the current month of cell A1, in the example above February.

    Thanks,

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,662

    Re: IF Formula showing date in cell above +1 day only if within month of date in another c

    There is circular reference btw B3 and B4. May be you mean that B3 refer to A1, instead of B4?

    If yes, try in B3:

    =EOMONTH(A1,-1)+1

    B4 = IF(MAX(B$1:B3)<A1,B3+1,"")

    Drag down until you get blank cell
    Quang PT

  3. #3
    Registered User
    Join Date
    01-12-2015
    Location
    Washington DC
    MS-Off Ver
    2013
    Posts
    3

    Re: IF Formula showing date in cell above +1 day only if within month of date in another c

    Yes, you were correct in your assumption, I did mean to refer to A1.

    The only change I made to your formula was to change A1 to $A$1.

    Thanks!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to show first day of the month based on date in another cell
    By Marco-Kun in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-11-2016, 10:46 AM
  2. [SOLVED] Showing a decline in Date/Month based on previous cell
    By avidcat in forum Excel General
    Replies: 5
    Last Post: 01-25-2014, 09:47 PM
  3. Replies: 5
    Last Post: 10-04-2012, 07:06 AM
  4. Replies: 4
    Last Post: 03-01-2012, 04:27 PM
  5. Calculate month-end date from date in adjacent cell?
    By Matt D Francis in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-19-2005, 12: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