Milestone dates to calculate a revenue payment

**bdlchicago** · 10-02-2014, 05:24 PM

So I've got three dates, and each date corresponds to an amount of money to be paid.

I'd like a formula that shows me the amount paid after a series of date milestones are reached.

something like this:

If date1<today,1000, 0
If date1 and date2<today, 2250,0
If date1 and date2 and date3<3500,0

thanks :-)

**bdlchicago** · 10-02-2014, 06:31 PM

I think I got this:

=IF(TODAY()>F2,3500,IF(TODAY()>E2,2250,IF(TODAY()>D2,1000,0)))

**glennchung** · 10-02-2014, 06:47 PM

Assuming A1 is date1, B1 is date2, C1 is date3, try this:

Formula:

Please Login or Register  to view this content.

This only works if all three date cells are populated.

**bdlchicago** · 10-04-2014, 12:11 AM

My method worked. With yours, there's always a payment. I needed to cover where none of the milestones had been reached yet.

Can you explain your use of AND in your statement? I don't get what that does exactly.