How to count even exact date 90 days

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

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

Note:

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

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,

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

A spelling error is better than no solution!

bgoree09 said:

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,

Click to expand...

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.

Cross post http://www.msofficeforums.com/excel/17927-how-count-even-exact-date-90-days.html

New cross post http://www.excelforum.com/excel-formulas-and-functions/955418-why-the-date-still-moving.html

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,