Need help calculating value based on age

[C Hayes]

I am starting a video game store. I have lists of games and releas
dates. Based on todays date and the release date I want to come u
with a value. Games that are 1-3 months old are $15, 4-6 months ol
are $12, 7-12 months old are $10 and a year and up are $5. Please hel
me make this work, it will save me a lot of time with updating th
value of games

 

[Norman Harker]

Hi C Hayes!

One approach:
A1:
Today:
A2:
Heading: Release Date
B2:
Heading: Value
A3: 23-Feb-2004 [Test date]
B3:
=IF(DATEDIF(A3,$A$1-1,"m")<=2,15,IF(DATEDIF(A3,$A$1-1,"m")<=5,12,IF(DATEDIF(A3,$A$1-1,"m")<=11,10,5)))

DATEDIF with the argument "m" counts the completed months between
start_date and end_date. To get it to match in with your requirement
of 3, 6, 12 and over 12 it is necessary to use 2,6,11 and over 11 and
to deduct 1 from Today's date.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH