Need help calculating value based on age

C

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
 
N

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
[email protected]

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
 
Top