# Thread: How to count even exact date 90 days

1. ## How to count even exact date 90 days

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.

2. Not certain if I understand your English. Are you looking for?

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

3. Note:

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

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,

5. @NBVC, simple auto-correct fail, : became ..

A spelling error is better than no solution!

6. Originally Posted by bgoree09
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. 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
•