Time from until today

  • Thread starter That's Confidential
  • 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
 
M

Michael

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
 

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

Word doc keeps changing to ALL CAPS 0
Search closest day in the past from today 2
If Formula and Dates 4
Date Conditional Formatting 4
Conditional Formatting Conundrum 3
Style Header Reformatted 3
Financial Time Value of Money calculations 5
Show value from one cell in another cell if today falls between a date range 5

Top