+ Reply to Thread
Results 1 to 4 of 4

Count days before expiry date & after Expiry date in one formula

  1. #1
    Registered User
    Join Date
    08-30-2011
    Location
    Australia
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    57

    Count days before expiry date & after Expiry date in one formula

    I am trying to count down the days before an expiry date, I can achieve this by using this formula which starts the countdown 90 days before expiry
    Please Login or Register  to view this content.
    I can achieve the days past expiry using
    Please Login or Register  to view this content.
    what I am unable to is achieve is joining these 2 formulas together to count before and after the expiry date.

    Any assistance would be greatly appreciated.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Count days before expiry date & after Expiry date in one formula

    Does this work?
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    BSB

  3. #3
    Registered User
    Join Date
    08-30-2011
    Location
    Australia
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    57

    Re: Count days before expiry date & after Expiry date in one formula

    Thanks BadleySpelledBouy that works for me, have marked this as solved.

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Count days before expiry date & after Expiry date in one formula

    Glad I could help.

    BSB

+ 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. Reminder mail by Excel 30 days before the expiry date.
    By Pramal11 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-29-2016, 05:45 PM
  2. Email Trigger needed 30 days before an MOT Expiry date.
    By gempinkfairy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-27-2014, 05:48 AM
  3. autocalculate expiry date / expiry date colour warnings
    By kimbling1 in forum Excel General
    Replies: 8
    Last Post: 08-27-2014, 02:53 AM
  4. Email to e sent if the expiry date is after 15 days
    By azmatullahkhan in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 03-29-2013, 01:04 PM
  5. Help completing VBA code that emails me when expiry date 30 days before.
    By MarkBone in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2013, 03:03 AM
  6. Set flag for expiry date 30 days in advance
    By Pat Meeneghan in forum Excel General
    Replies: 9
    Last Post: 11-27-2012, 09:40 AM
  7. Replies: 7
    Last Post: 09-04-2009, 10:17 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