Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

is there is any formula for exel to calculate how many days from specific date until today ?

for example if i wrote in column A 31 july

so from 31 july until 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
up vote 3 down vote accepted


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


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
The format must be acceptable to Excel. For details see – 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


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.