Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

is there is any formula for exel to calculate how many days from speefic date untill today ?

for exp if i wrote in collume A 31 july

so from 31 july untill today it's 4 days

i don't want to calculate manually as i have huge dates

can u help me with this please

share|improve this question

1 Answer 1

up vote 3 down vote accepted

=today()-a1

will return decimals, for example 1.5 for 1 day and 12 hours.

=int(today()-a1)

will return just the whole number

share|improve this answer
    
thanks alot i need: =int(today()-a1) can i change the formula today to 31 july 2010 ? i tried but i got error –  khalid Aug 3 '10 at 7:36
1  
The format must be acceptable to Excel. For details see support.microsoft.com/kb/214094 –  harrymc Aug 3 '10 at 7:50
    
still i can't use the format that i want exactly, ( replace today date with 31 july 2010 but thanks for ur help. it's realy save my time now thanks alot –  khalid Aug 3 '10 at 9:53

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.