1 year ago
#379922
user18314386
Using Dates in If Function
I need to determine eligibility as per interval dates with the condition of completing 1 year based on the current date
for instance :
Year 2021 Start Date 1-Mar 2020 competing 1 year in 1-Mar 2021 --> "Eligible"
After the date 1-Mar 2022 the status will be --> "Not Eligible" for the year 2021 and "Eligible" for the year 2022 and so on.
Below the formula I used
=IF(MONTH(TODAY())>=DATE(2020,MONTH(G3),DAY(G3)),"Eligible","Not Eligible")
Pic from Excel
excel
spreadsheet
0 Answers
Your Answer