+ Reply to Thread
Results 1 to 3 of 3

Dates plus or minus a certain amount of days.

  1. #1
    Registered User
    Join Date
    05-30-2018
    Location
    Cary, North Carolina
    MS-Off Ver
    Office 365
    Posts
    1

    Dates plus or minus a certain amount of days.

    Good afternoon.

    I know the title of my email is a bit confusing, allow me to explain

    My job uses equity based billing, so to figure out certain billing dates, I need to have the next billing date minus 5 days. I have to repeat this multiple times, which is why I am looking for a formula for this.

    For example, if I put in 05/10/2018, I would want the next cell to display 06/05/2018.

    Is there a formula for this? I've always had bad luck with formulas for dates.

    Thanks for your help.

    -MP-

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,501

    Re: Dates plus or minus a certain amount of days.

    this would be one way...
    =EDATE(A1,1)-5
    where 5/10/2018 is in cell A1
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,501

    Re: Dates plus or minus a certain amount of days.

    thanks for the rep!

+ 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] Subtract dates to give a total amount of days - Multiple Data
    By t_man000 in forum Excel General
    Replies: 2
    Last Post: 07-23-2015, 11:14 PM
  2. [SOLVED] Highlight dates within 'x' amount of days
    By rhodestransit in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-27-2012, 01:57 PM
  3. [SOLVED] Macros for: If Today's Date minus other date is greater than certain amount of days Then
    By lottidotti in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-24-2012, 04:46 PM
  4. Replies: 5
    Last Post: 12-15-2011, 11:16 AM
  5. [SOLVED] Calculate Number of Days Between Dates Minus Weekends
    By Melissa in forum Excel General
    Replies: 3
    Last Post: 03-06-2006, 03:25 PM
  6. [SOLVED] Chronolize dates with varying days minus weekends
    By Sheila in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-10-2006, 02:45 PM
  7. Chronolize dates with varying days minus weekends
    By Sheila in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-10-2006, 11:25 AM

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