I'm having a real brain-fart moment. I'd like to have a calculation that compares two dates and returns the value of "Age" in number of years. For example
- 1/1/13 to 1/1/14 would return 1
- Anything less than that would return 0
- Anything more than one year would return the number of years
The issue I'm having is that if you only use the Year ( xxx) function then an item from December of last year looks like it's a year old now, even though it's only a month old. Can someone give me a function that takes into account exactly 365 days when comparing? I've tried a few different things and haven't had any luck. I'm sure I'm just missing something small.
Does this make sense? Thanks!