+ Reply to Thread
Results 1 to 4 of 4

Calculate weeks if date is less than 7 days from end of month

Hybrid View

  1. #1
    Registered User
    Join Date
    11-13-2011
    Location
    Hamilton, Ontario
    MS-Off Ver
    Excel 365
    Posts
    4

    Calculate weeks if date is less than 7 days from end of month

    Have a simple spreadsheet in Excel 365 with a column of cells for each week of the month.
    A3 = 21/02/01 A4 = A3+7 A5=A4+7 A6=A5+7 This is fine for February, but for March we have to add an extra row for the extra week. Is there a way to show IF the date in A6 is within 7 days of the end of month, then leave the cell blank, otherwise show A6+7

    Thank you

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    3,219

    Re: Calculate weeks if date is less than 7 days from end of month

    You should update your profile to show MS365 as your version.
    In A6, try:
    =IF(EOMONTH(A6,0)-A6<7,"",A6+7)

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

    Re: Calculate weeks if date is less than 7 days from end of month

    A4:
    =MIN(EOMONTH(A3,0),A3+7)
    Drag down
    Quang PT

  4. #4
    Registered User
    Join Date
    11-13-2011
    Location
    Hamilton, Ontario
    MS-Off Ver
    Excel 365
    Posts
    4

    Re: Calculate weeks if date is less than 7 days from end of month

    thank you both- Solved!

+ 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] how to calculate days, month from two different date given ?
    By vengatvj in forum Excel General
    Replies: 2
    Last Post: 07-19-2016, 03:01 PM
  2. Replies: 14
    Last Post: 04-06-2015, 09:19 PM
  3. How to calculate how many weeks a month, and the remaining days
    By Frantzizko in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-29-2014, 08:35 AM
  4. [SOLVED] calculate No. of days between two date WITHIN A CURRENT MONTH
    By peteryt in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 03-16-2014, 10:53 AM
  5. Replies: 4
    Last Post: 05-03-2013, 12:45 PM
  6. Calculate days in month after a given date
    By Grimace in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-20-2010, 12:41 AM
  7. calculate No. of days between two date WITHIN A CURRENT MONTH
    By ahgoon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-02-2009, 04:48 PM

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