Date Maniplation

[Satishwin123]

Hi,

I want to find the difference in date from the below dates in the form

yyyy-mm-dd

Eg:

Start date = 1980-02-22
End date = 1966-11-29

Result should be in yyyy-mm-dd format.

Pl.help.

Thanks
Satish.

 

[Ron Rosenfeld]

Hi,

I want to find the difference in date from the below dates in the form

yyyy-mm-dd

Eg:

Start date = 1980-02-22
End date = 1966-11-29

Result should be in yyyy-mm-dd format.

Pl.help.

Thanks
Satish./

In Excel, "real" dates are stored as serial numbers with 1 = 1 Jan 1900. You can format the cell to display the date however you wish, including yyyy-mm-dd.

So to determine the difference between two dates, you merely subtract one from the other. That gives you a value in days, although you may have to change the format of the cell containing the formula.

However, you will need to be more specific as to how you want the results displayed. Days and weeks are simple. But since neither years, nor months have a fixed number of days, you will need to provide unambiguous details as to how you wish these computations to be made.