Sort column by formula result

R

Ryan

I need to sort a column by the result of the formula in that cell...Is this
possible?

Basically I have a column full of dates (which are generated by formulas
related to cells within the column and other cells), and I need to be able to
sort the column by the result of the formulas.

Thanks
Ryan
 
R

Ryan

I only use simply formulas like cell a1 is a date, then cell b1 would be
=a1+12 (days)

any idea how i can make this work?
 
B

bj

if you sort both columns this equation would sort.
if you do only column b you would not see a difference, you should use
absolutye references such as
=$A1 + 12
 
Top