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 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


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

Report •


✔ Best Answer
May 13, 2016 at 12:01:38
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 time the 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



#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?

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

message edited by DerbyDad03


Report •

#2
May 12, 2016 at 07:18:19
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


Report •

#3
May 12, 2016 at 07:27:29
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

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?

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


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 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 is EXACTLY two weeks?
The same applies to all of your conditions.


MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#7
May 13, 2016 at 12:01:38
✔ 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 time the 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


Report •

Ask Question