# Solved Hi , I want a if formula for the below If a date is less t

May 12, 2016 at 07:02:50
Specs: Windows xp, 3gb
 Hi ,I want a if formula for the belowIf a date is less than 2 weeks from today then it should reflect as BUCKET CIf a date is more than 2 weeks from today and less than 1 month then it should reflect BUCKET DIf a date is more than 1 month and less than 3 months then it should reflect as BUCKET E

See More: Hi , I want a if formula for the below If a date is less t

May 13, 2016 at 12:01:38
 re: "Be aware that the =TODAY() function is termed volatile, every day your formulawill 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 time the sheet calculates, even if the precedent data does not change. Too many volatile functions can cause significant performance degradation in a workbook.message edited by DerbyDad03

#1
May 12, 2016 at 07:07:53
 More than or less than in which direction - before or after or both?What if the date is more than 3 months away?message edited by DerbyDad03

Report •

#2
May 12, 2016 at 07:18:19
 Hi ,I want a if formula for the belowIf a date is less than 2 weeks from today then it should reflect as BUCKET CIf a date is more than 2 weeks from today and less than 1 month then it should reflect BUCKET DIf a date is more than 1 month and less than 3 months then it should reflect as BUCKET EIf a date is more than 3month and less than 6months then it should reflect as BUCKET FIf a date is more than 6month and less than 1year then it should reflect as BUCKET GIf 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 IIf a date is more than 5years then it should reflect as BUCKET JI want formula for this

Report •

#3
May 12, 2016 at 07:27:29
 Hi ,I want a if formula for the belowIf a date is less than 2 weeks from today then it should reflect as BUCKET CIf a date is more than 2 weeks from today and less than 1 month then it should reflect BUCKET DIf a date is more than 1 month and less than 3 months then it should reflect as BUCKET EIf a date is more than 3month and less than 6months then it should reflect as BUCKET FIf a date is more than 6month and less than 1year then it should reflect as BUCKET GIf 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 IIf a date is more than 5years then it should reflect as BUCKET JI want formula for this

Report •

Related Solutions

#4
May 12, 2016 at 08:00:57
 You have not answered my question:More than or less than in which direction - before or after or both?

Report •

#5
May 12, 2016 at 09:16:19
 In both the direction , less than today and more than 5years from today

Report •

#6
May 13, 2016 at 06:00:25
 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 formulawill evaluate the formula with TODAY's date, and since tomorrow is not the samedate 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 monthbut you did not specify what is to happen if the date is EXACTLY two weeks?The same applies to all of your conditions.MIKEmessage edited by mmcconaghy

Report •

#7
May 13, 2016 at 12:01:38