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.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.