S saneesh New Member Oct 2, 2011 #1 Hi, I have one column with 1000 dates and i have on particular date with me...according to this date i want to divide this date into 3.that is <45,45-90 days,>90days Could you please arrange me a formula for this.. Regards Sannesh
Hi, I have one column with 1000 dates and i have on particular date with me...according to this date i want to divide this date into 3.that is <45,45-90 days,>90days Could you please arrange me a formula for this.. Regards Sannesh
Mike86 Active Member Oct 2, 2011 #2 There are many ways to do this. Something like this will work: =IF(A1<today()-45,IF(A1<Today()-90,"Older Than 90","45-90"),"45 or Newer") Change the text strings to match the output you'd like.
There are many ways to do this. Something like this will work: =IF(A1<today()-45,IF(A1<Today()-90,"Older Than 90","45-90"),"45 or Newer") Change the text strings to match the output you'd like.
