Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1014
  • Last Modified:

Calculate days between dates

Experts,
This is too easy for some but not me:

Subtract 3/17/2008 from 2/15/2008. How many days?
0
Frank Freese
Asked:
Frank Freese
1 Solution
 
barry houdiniCommented:
If you have the dates in cells you can just subtract one from another, e.g. with laer date in B2

=B2-A2

or with the dates in the formula

=DATE(2008,3,17)-DATE(2008,2,15)

either way format the result cell as general

regards, barry
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now