To extend the given formula for the additional steps, you can use the IF function again to check if the current date is less than the date in column H2 (assuming H2 contains the dates). If the condition is true, the formula will return an empty string (""); otherwise, it will return the value from the corresponding row in column D. Here's the extended formula:
=IF(H2<TODAY(), "", IF(ISBLANK(D2), "", D2))
In this formula, the outer IF function checks if the current date is less than the date in column H2. If the condition is true, it returns an empty string (""); otherwise, it proceeds to the inner IF function. The inner IF function checks if the value in column D is blank. If the value is blank, it returns an empty string (""); otherwise, it returns the value from column D.
By adding this additional IF function, the formula will first check if the current date is less than the date in column H2. If it is, it will return an empty string. If the current date is not less than the date in column H2, it will check if the value in column D is blank. If it is, it will return an empty string; otherwise, it will return the value from column D.