Results 1 to 9 of 9

Thread: How to count even exact date 90 days

  1. #1

    How to count even exact date 90 days



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all

    I need help. If total day has achieved 90 days or more in G5 cell to G12, cell will change to yellow. If I wanted exact date cell achieve even 90 days and displayed in G14 cell , what formula that must be used.

    Attached file for reference.
    Attached Files Attached Files

  2. #2
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    Not certain if I understand your English. Are you looking for?

    = now() + 90 - sum(G5..G12)

  3. #3
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,429
    Articles
    0
    Excel Version
    Excel 2016
    Note:

    sum(G5..G12) is not an EXCEL function.


  4. #4
    Good morning,

    I think this is what you're looking for. I had to add a couple columns in the margin to the right. These could be hidden, but I left them for reference.

    Best of luck,
    Attached Files Attached Files

  5. #5
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    @NBVC, simple auto-correct fail, : became ..

    A spelling error is better than no solution!

  6. #6
    Quote Originally Posted by bgoree09 View Post
    Good morning,

    I think this is what you're looking for. I had to add a couple columns in the margin to the right. These could be hidden, but I left them for reference.

    Best of luck,

    Thanks bgoree09 for your help. Why date in G14 cell still moving when day skip 91 or more. Can or not date stopped automatically when achieve 90 days even date in B cell and C filled.

  7. #7
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,315
    Articles
    0
    Excel Version
    2010 on Xubuntu

  8. #8
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,315
    Articles
    0
    Excel Version
    2010 on Xubuntu

  9. #9
    Hello again,

    Sorry I thought my formula was doing something it wasn't. Wrap the formulas in your "Eligible" column in ROUND(--formula---,0) and use the formula below in g14

    =IFERROR(INDEX($C$5:$C$12,MATCH(90,$H$5:$H$12,0)),INDEX($F$5:$F$12,MATCH(SUMIFS($F$5:$F$12,$H$5:$H$12,"<"&90),$I$5:$I$12,1)+1)*(90-(INDEX($H$5:$H$12,MATCH(SUMIFS($F$5:$F$12,$H$5:$H$12,"<"&90),$I$5:$I$12,1))))/(INDEX($G$5:$G$12,MATCH(SUMIFS($F$5:$F$12,$H$5:$H$12,"<"&90),$I$5:$I$12,1)+1))+(INDEX($B$5:$B$12,MATCH(SUMIFS($F$5:$F$12,$H$5:$H$12,"<"&90),$I$5:$I$12,1)+1)))

    Maybe this will work better for you. Sorry about that,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •