Date Calculation
 

I import some data that gives me a date field that looks like this
"8/3/2005" in column A. I need a formula that will calculate how many days
are left until this field is 30 days old based on the date. This is an
invoice date and I have thirty days to file a claim for any descrapancies. I
would like to know how many days I have left.

T.I.A.

hi
try something llike this....
=(a2+30)-TODAY()

regards
FSt1

"Grant" wrote:

I import some data that gives me a date field that looks like this
"8/3/2005" in column A. I need a formula that will calculate how many days
are left until this field is 30 days old based on the date. This is an
invoice date and I have thirty days to file a claim for any descrapancies. I
would like to know how many days I have left.

T.I.A.

If the dates are true excel dates (numeric) then just add 30 days

=A1+30

Where A1 holds the date



--
Regards,

Peo Sjoblom

(No private emails please)


"Grant" wrote in message
...
I import some data that gives me a date field that looks like this
"8/3/2005" in column A. I need a formula that will calculate how many days
are left until this field is 30 days old based on the date. This is an
invoice date and I have thirty days to file a claim for any descrapancies.
I would like to know how many days I have left.

T.I.A.

Try a formula of =MAX(0,A2+30-TODAY())

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Grant" wrote in message
...
I import some data that gives me a date field that looks like this
"8/3/2005" in column A. I need a formula that will calculate how many days
are left until this field is 30 days old based on the date. This is an
invoice date and I have thirty days to file a claim for any descrapancies.
I
would like to know how many days I have left.

T.I.A.

Sorry, didn't see the countdown part, use

=(A1+30)-TODAY()

--
Regards,

Peo Sjoblom

(No private emails please)


"Peo Sjoblom" wrote in message
...
If the dates are true excel dates (numeric) then just add 30 days

=A1+30

Where A1 holds the date



--
Regards,

Peo Sjoblom

(No private emails please)


"Grant" wrote in message
...
I import some data that gives me a date field that looks like this
"8/3/2005" in column A. I need a formula that will calculate how many days
are left until this field is 30 days old based on the date. This is an
invoice date and I have thirty days to file a claim for any descrapancies.
I would like to know how many days I have left.

T.I.A.