Hi
I'm working on a sheet with 3 columns
A1 B1 C1 D1
=Date ran =use buy = blank or =days remaining
no work from
todays date

to use buy date


example:
In A1 is date ran 1/12/08, B1 needs to be 1 year from date ran, 1/12/09. i'm
using =DATE(YEAR(A14)+1,MONTH(A14),DAY(A14)) in B1 and it seems to work. no
onto C1, this is the one i can't figure out, if C1 is blank B1 needs to show
date, if B1 contains the words no work, then i need B1 and D1 to be blank, in
D1 i'm using this formula (thanks to the search fuction)
=DATEDIF(TODAY(),MAX(A14,DATE(YEAR(TODAY())+(DATE( YEAR(TODAY()),MONTH(B14),DAY(A14))TODAY())+1,MONT H(A14),DAY(A14))),"d") and it also seems to work.

thanks for any help you can offer.