+ Reply to Thread
Results 1 to 6 of 6

Need help with a formula to calculate dates.

  1. #1
    Registered User
    Join Date
    03-15-2019
    Location
    Maine, US
    MS-Off Ver
    MS Office 10
    Posts
    3

    Need help with a formula to calculate dates.

    So this is not as simple as the title makes it out to be. I need to add a month to the date listed in C5 and display it in F7, but only if the date in C5 is lower than the date listed in C6. The output to F7 also needs to read "Next Due Date: (date from either C5 or C6) - $(amount listed on C7). I would appreciate any assistance. Below is an image so you can see what I am working with.

    example.png

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Need help with a formula to calculate dates.

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    03-15-2019
    Location
    Maine, US
    MS-Off Ver
    MS Office 10
    Posts
    3

    Re: Need help with a formula to calculate dates.

    I hope this is what you asked for. It is a before and after workbook.
    Attached Files Attached Files

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Need help with a formula to calculate dates.

    Thank you. Try this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    03-15-2019
    Location
    Maine, US
    MS-Off Ver
    MS Office 10
    Posts
    3

    Re: Need help with a formula to calculate dates.

    That is perfect! Thank you so much!

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Need help with a formula to calculate dates.

    You're welcome.


    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ 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. Formula to calculate dates based off RIGHT CMD
    By randy2012 in forum Excel Formulas & Functions
    Replies: 30
    Last Post: 02-23-2017, 01:24 PM
  2. Formula to calculate days, dates
    By matthewhinds in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-12-2014, 01:16 AM
  3. Formula to calculate age from two dates
    By lisa_turin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2014, 10:06 AM
  4. Replies: 1
    Last Post: 02-02-2013, 02:28 PM
  5. Replies: 1
    Last Post: 11-01-2012, 03:41 PM
  6. formula to calculate dates! HELP!
    By hermie2000 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-09-2006, 11:54 AM
  7. Can someone help with a formula to calculate dates?
    By SharonP. in forum Excel General
    Replies: 11
    Last Post: 08-09-2005, 09:07 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