Date calculation in Excel97

[wyld]

I have a column containing the date in YYYYMMDD format. I want to create a formula that will calculate how 'old' the record is.

For example, the formula would return the result of 4 for the date 20010601 (assuming today is June 5, 2001).

Thanks in advance!

 

[HOMMER]

What program excel or access?

 

[wyld]

It's in Excel 97.

 

[HOMMER]

Use the datedif function (you can look this up in the help file for examples). You can replace the date with cells that have the date in them.
Hope this helps


=DATEDIF("2001/06/01","2001/06/05","d&quot

A1 = 2001/06/01 A2 = 2001/06/05
=DATEDIF("A1","A2","d&quot

 

[wyld]

Thanks for the prompt help....I'll give it a try tomorrow.

*s*

 

[JohnYingling]

change that a little to
=DATEDIFF("d",Date1,Date2)
Ypu may need to use DateValue or DateSerial to get a DATE type before using datediff.

on error resume next
dte1 = dateSerial(Cint(Mid(strdte,1,4)), _
                  Cint(Mid(strdte,5,2)), _
                  Cint(mid(strdte,7,2))
if err.number <> 0 then .....bad date
on err goto 0 
 [URL unfurl="true"]WWW.VBCompare.Com[/URL]

 

[JVFriederick]

To calculate the rounded number of days from a YYYYMMDD format, for a date in cell D1, use the formula :

=INT(NOW()-DATE(ROUND(D1,-4)/10000,ROUND(D1,-2)/100-ROUND(D1,-4)/100,D1-ROUND(D1,-2)))

Use copy and paste from this posting. Save your fingers.

 

[wyld]

Thanks guys! Worked like a charm.