updating date based on another cells value

Ok...here's a full explanation of what i'm trying to do.....

column b contains the date for each entry. i would like for cell e6 to update +60 whenever the MOST recent entry (date found in b column, value found in k column) is >0 is put into any cells from k10:k365. all i know is that i'll need something like a max(b10:b365). in case that didn't all come out clear.......

i put a date in column b
if i put a value >0 in k column....
....i want the e6 cell to show +60 days from whatever the most RECENT date is with the most RECENT k column data, so it's always updating another 60 days into the future whenever i put a value into the k column, based off whatever the last date had a value in the k column....have i thoroughly spoken in circles? thanks ahead of time.

Perhaps you can use this formula

=MAX(IF(K10>K365>0,B10:B365))+60

This is an array formule that needs to be confirmed with CTRL+SHIFT+ENTER so that curly braces like { and } appear around the formula in the formula bar

apologies. in iraq with u.s. excel. would the formula you listed be added onto the end of the pre-existing one?

the original formula i was using was

=MAX(IF(K10:K365>0,B10:B365))+60

which is updating my date in cell e6 based off any value in column k with the most recent date. what i would like to happen is that when today's date is greater than the value of e6, that e6 then display "expired."

ah...and yet something's not quite right, as i'm getting a "value not available" error. i've check, check, and rechecked both my description, my cells being used, and the formula being typed in, yet there error persist.

here goes...

i removed the formula because it did not work. here it is from the top....


column b contains the date for each entry. i would like for cell e6 to update +60 whenever the MOST recent entry (date found in b column, value found in k column) is >0 is put into any cells from k10:k365. all i know is that i'll need something like a max(b10:b365). in case that didn't all come out clear.......

i put a date in column b
if i put a value >0 in k column....
....i want the e6 cell to show +60 days from whatever the most RECENT date is with the most RECENT k column data, so it's always updating another 60 days into the future whenever i put a value into the k column, based off whatever the last date had a value in the k column....have i thoroughly spoken in circles? thanks ahead of time.

so again, the cell i want the display in is e6.

the cell should be the most recent (max) date from b10:b365 when there has been a number >0 in the k10:k365 with 60 days added onto that date. in the event that todays date is greater than the date in e6, it should state "expired." thanks again.