Using a formula/calculation based on day or dates selected

[#1]

I have a scenario as follows.

Based on the date or date range selected if the date or date range is before 08/29/2016, I wanted to it to do one calculation (e.g A + B) and if anything after 08/29/2016 is selected, it does a different one (A + B + C).

I am doing something like this at the moment,

if(ADate < '08/29/2016', A + B, A + B +C).

The above works if I made ONE date selection only which is prior to 08/29/2016 but if I select a date range for e.g Aug 10-13, it does not work.

Any help/advice would be much appreciated.

Thank you,
Amit

[settu_periasamy · Accepted solution]

May be try

if(Max(ADate)< '08/29/2016', A + B, A + B +C)

[#3]

Thank you! This solved it.