1 year ago

#379922

test-img

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

enter image description here

excel

spreadsheet

0 Answers

Your Answer

Accepted video resources