|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.
message edited by mmcconaghy