Copy rows with specific data to another sheet automaticaly

Hello,

I am new to this forum and appreciate worth of all who want to help and share knowledge.

I would like to extract or copy rows from one sheet with dates which are 3 or less days distant from today.

Foe example, in column E - I have a deadline dates. In column F - based on formula, =(E2-TODAY())) I got days to deadline.

I want to know is there any formula to extract rows which contain values 3 or less than 3 in cells in column F, and paste that rows in another sheet as list of deadlines with condition values between 0 to 3. It would be nice to get comment if values are less than 0 (negative values) that deadlines are missed.

Can this be done with formulas or it must be macro or VBA ?

Thanks in advance