I am none the wiser.
So column A has a manually entered date. Column D will identify Priority. If date in column A is greater than 90 days old from today’s date then column D should state “2”. If the date in column A is less than 90 days old then column D should state “3”. Column F shows a deadline and what I want to do is, if column F shows a deadline date, then column D must show “1” as this will be high priority. Any help what formula I should use?