I have quick requirement to copy empty cells with previous value till existence of data till today. I have used 'PREVIOUS_VALUE' function, I may have future date also, But I would like to consider till today only. Here is screenshot, C4 should have values of DD till November 2017 because F2 has value till Nov 2017(we should ignore values in future). Pl let me know how to write the calculation. Thank you in advance.