Date Calculation

  • Thread starter Thread starter Grant
  • Start date Start date
G

Grant

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)
 
Try a formula of =MAX(0,A2+30-TODAY())

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Sorry, didn't see the countdown part, use

=(A1+30)-TODAY()

--
Regards,

Peo Sjoblom

(No private emails please)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IS THERE A FORMULA TO CALCULATE THE DISTANCE BETWEEN DATES 2
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
I need help with a Function 0
Skipping weekends during a count 1
Calculating date/time intervals?? 1
How do I get a new calculated date from different date ranges? 3
COUNTIF & Dates 0
Problem formatting dates from CSV file 2

Back
Top