+ Reply to Thread
Results 1 to 4 of 4

Date and if formula help

  1. #1
    Forum Contributor
    Join Date
    11-01-2014
    Location
    London, England
    MS-Off Ver
    Mac 2016
    Posts
    108

    Date and if formula help

    Hi

    I need to show when a date is more than six months. I have used a date if formula to show the difference as year-month-days. I now need a formula to show if the difference is more than six months that i am struggling with.

    I have attached a spreadsheet to help demonstrate what i am looking for.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,404

    Re: Date and if formula help

    Put this in D3 and drag down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    That gives the results you want, except for D7, but I think you wanting a blank there is a mistake?
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Forum Contributor
    Join Date
    11-01-2014
    Location
    London, England
    MS-Off Ver
    Mac 2016
    Posts
    108

    Re: Date and if formula help

    that's perfect, thank you :-)

  4. #4
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,404

    Re: Date and if formula help

    You're welcome, glad I could help and 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] Formula for converting a date to quarter and leaving blank cell for no date values
    By jayc2111 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-10-2019, 12:57 AM
  2. Replies: 4
    Last Post: 03-21-2018, 09:25 AM
  3. Replies: 7
    Last Post: 02-02-2017, 02:41 PM
  4. Replies: 5
    Last Post: 12-01-2015, 02:36 PM
  5. [SOLVED] Formula to compare date (including month and year) from a listed date to today's date
    By mhewitson15 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2014, 05:31 PM
  6. Replies: 2
    Last Post: 11-03-2014, 10:29 AM
  7. [SOLVED] Formula assistance needed to sum data based on anniversary date and month date
    By lilsnoop in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-28-2012, 11:18 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