I want to calculate the years between two dates. One of the dates is to be a future date (1 September) in the current year. How do I express "current year" in the formula? I may want to look at the results of the calculation in June of the current year but I want the calculation to reflect what the result would be on 1 September of the current year.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Current Year calculation question
- Thread starter retmet
- Start date
Similar threads
- Locked
- Question
- Locked
- Question