How to use date formulas when I care only about month and year
Have a specific project that needs to compute expiration dates but days are not relevant. Only the month and year is tracked and input into our logs. I need a workaround that computes whether 5 years and 1 year has passed for different input mm/yy dates, and give me a YES or NO for whether the part is in spec.
Example:
Manually input inspection date on part: 02/23
5-year interval in spec: yes 1-year interval in spec: no
What I'm using so far =IF(EDATE(D2,60) - TODAY() > 0, "YES" , "NO")
It doesn't work because the system misreads my input date (02/23) as the 23rd day of February of the current year, not as February of 2023.
How do I set the system to read my month/year inputs correctly? Typing in the full date format (for example: 01/02/23 as day/month/year) is not an option. Any coding behind the scenes to temporarily convert our inputs is though.