formula help
thanks, that worked great, once i figured out what you meant by "what you
want to happen", so i just deleted the wording and left the quotes now it
shows a blank cell when it needs to.
thanks again.
"Luke M" wrote:
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.
|