See attached:
When Column A has the same ID and Column D = "Final" OR "Interim", subtract Column E (date 1) from Column F (date 2) to output the difference in days in Column G.
- Column F (Date 2) could have different dates for the same ID in Column A. The calculation should use the most recent date in Column F (Date 2).
- If Column E (date 1)- Column F (date 2) results in a negative value, output a "N/A"
- If either date field Column E (date 1) OR Column F (date 2) is blank, output a "-"
Bookmarks