Hi , I want a if formula for the below

If a date is less than 2 weeks from today then it should reflect as BUCKET C

If a date is more than 2 weeks from today and less than 1 month then it should reflect BUCKET D

If a date is more than 1 month and less than 3 months then it should reflect as BUCKET E

✔ Best Answer

re: "Be aware that the =TODAY() function is termed volatile, every day your formula

will evaluate the formula with TODAY's date,..."To be a bit more precise, the issue with TODAY() being volatile is not the daily change but the fact that the TODAY() function will calculate

every single timethe sheet calculates, even if the precedent data does not change. Too many volatile functions can cause significant performance degradation in a workbook.http://www.decisionmodels.com/calcs...

message edited by DerbyDad03

More than or less than in which direction - before or after or both? What if the date is more than 3 months away?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

Hi , I want a if formula for the below

If a date is less than 2 weeks from today then it should reflect as BUCKET C

If a date is more than 2 weeks from today and less than 1 month then it should reflect BUCKET D

If a date is more than 1 month and less than 3 months then it should reflect as BUCKET E

If a date is more than 3month and less than 6months then it should reflect as BUCKET F

If a date is more than 6month and less than 1year then it should reflect as BUCKET G

If a date is more than 1year and less than 2yearsthen it should reflect as BUCKET HIf a date is more than 2years and less than 5years then it should reflect as BUCKET I

If a date is more than 5years then it should reflect as BUCKET J

I want formula for this

Hi ,

I want a if formula for the below

If a date is less than 2 weeks from today then it should reflect as BUCKET C

If a date is more than 2 weeks from today and less than 1 month then it should reflect BUCKET D

If a date is more than 1 month and less than 3 months then it should reflect as BUCKET E

If a date is more than 3month and less than 6months then it should reflect as BUCKET F

If a date is more than 6month and less than 1year then it should reflect as BUCKET G

If a date is more than 1year and less than 2yearsthen it should reflect as BUCKET H

If a date is more than 2years and less than 5years then it should reflect as BUCKET I

If a date is more than 5years then it should reflect as BUCKET J

I want formula for this

You have not answered my question:

More than or less than in which direction - before or after or both?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

In both the direction , less than today and more than 5years from today

Here is a formula that uses the =DATEDIF() function and the =TODAY() function. Be aware that the =TODAY() function is termed volatile, every day your formula

will evaluate the formula with TODAY's date, and since tomorrow is not the same

date as today, it will change.The formula is only for your first three conditions:

=IF(DATEDIF(A1,TODAY(),"D")<14,"Bucket C",IF(DATEDIF(A1,TODAY(),"M")<1,"Bucket D",IF(DATEDIF(A1,TODAY(),"M")<3,"Bucket E")))

The formula, as written is NOT complete.

Your request was for:

If a date is more than 2 weeks from today and less than 1 month

but you did not specify what is to happen if the date isEXACTLYtwo weeks?

The same applies to all of your conditions.

MIKE

message edited by mmcconaghy

re: "Be aware that the =TODAY() function is termed volatile, every day your formula

will evaluate the formula with TODAY's date,..."To be a bit more precise, the issue with TODAY() being volatile is not the daily change but the fact that the TODAY() function will calculate

every single timethe sheet calculates, even if the precedent data does not change. Too many volatile functions can cause significant performance degradation in a workbook.http://www.decisionmodels.com/calcs...

message edited by DerbyDad03

Ask Your Question

Weekly Poll