In B14:
=IF(C14="No work","",DATE(YEAR(A14)+1,MONTH(A14),DAY(A14))

Note that by making B possibly blank, you'll need to account for that in
column D
In D14
=IF(B14="","What do you want to happen?",B1-TODAY())
And format cell as number.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Bowmanator" wrote:

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.