# 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

#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

#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

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?

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