date subTRACTION

[a.janmohammadi]

Hello friends,
Does anyone know how I can subtract dates?
and in what formats Excel is able to make it available ?
Thanks in advance.

[mehmetcik]

Excell will do that automatically if your data looks like a date

in A1 enter

Please Login or Register  to view this content.

in B1 enter your birthday like 25/12/2016

in C1 enter =A1-B1

[Tony Valko]

In Excel dates are really just numbers formatted to look like dates. These numbers are commonly referred to as the date serial number. The date serial number is the count of days starting from a base date. In Windows Excel the default base date is January 1, 1900. So, January 1, 1900 is date serial number 1.

Jan 1 1900 = date serial number 1
Jan 2 1900 = date serial number 2
Jan 3 1900 = date serial number 3
Jan 4 1900 = date serial number 4
Jan 5 1900 = date serial number 5
etc
etc
Jan 1 1975 = date serial number 27395
Jan 1 2000 = date serial number 36526
Jan 1 2016 = date serial number 42370

You can see the date serial number by entering some date in a cell and then changing that cells format to General or Number.

So, the difference in dates can be done with simple subtraction.

=EndDate-StartDate

A1 = StartDate = 11/1/2016
B1 = EndDate = 11/13/2016

=B1-A1

Formatted as General or Number

Result = 12