Sunshine8790
Board Regular
- Joined
- Jun 1, 2021
- Messages
- 86
- Office Version
- 365
- Platform
- Windows
I have the below formula to help me calculate years for the current month based on a date in K2.
How can I modify this to reflect a new need?
I don't need it for current month anymore, I need to show how many years based on L2 (which contains only the year of the full date) for next year.
For example:
If the date in L2 is 2024, I need K2 to say "1".
If the date in K2 is 2015, I need K2 to say "10"
Help appreciated
How can I modify this to reflect a new need?
I don't need it for current month anymore, I need to show how many years based on L2 (which contains only the year of the full date) for next year.
For example:
If the date in L2 is 2024, I need K2 to say "1".
If the date in K2 is 2015, I need K2 to say "10"
Excel Formula:
=IFERROR(DATEDIF(K2,EOMONTH(NOW(),0),"Y"),"Inactive")
Help appreciated
