Time from until today

  • Thread starter Thread starter That's Confidential
  • Start date Start date
T

That's Confidential

I want to work out how many days have fell since a specific date until today
(as in the day the spreadsheet is getting viewed!)

So for example, in a cell, I want to work out how many days have fallen
since 12th February until today. Any ideas?

Thanks in advance
 
Hi
If your specified date is in A1 and your today date is B1
In C1 type =B1-A1
Make sure that both cells contain dates and not text or it
won't work
Regards
Michael
 
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

I need help with a Function 0
I need Help with a date calculator 0
Formula Problems.... if then else? 1
Formula Returning Records # of Days from Today in Excel 2
Excel How to get the number of days an item was opened from the today's date. 14
Financial Time Value of Money calculations 5
Them delivery services - some good, some not so good 3
Skipping weekends during a count 1

Back
Top