I thought I would ping the Community for assistance on how best to handle this request. I'm trying to create a formula field that would show a year for all records that occurred prior to that year-end date. The formula below does not work. Any ideas? IF(Funding_Completed_Date__c <= DATEVALUE("2021-12-31")), "2021", IF(Funding_Completed_Date__c <= DATEVALUE("2022-12-31")), "2022", IF(Funding_Completed_Date__c <= DATEVALUE("2023-12-31")), "2023", IF(Funding_Completed_Date__c <= DATEVALUE("2024-12-31")), "2024", IF(Funding_Completed_Date__c <= DATEVALUE("2025-12-31")), "2025", "N/A"))))) Thanks, Michael
