CODEWITHSUNDEEP
excelexcel-2007excel-formula
MultiformeIngegno
MultiformeIngegno

Reputation: 7049

Excel: return date from days count

In a cell I have a starting date (e.g. 01 Jan 2000). What function allows me to print the exact date after an amount of days (01/01/2000+ e.g. 165,728066 days). It should count for months with 28,30 and 31 days of course. It should be something like (~) 15 June 2000

Upvotes: 1

Views: 219

Answers (4)

KevinKSY
KevinKSY

Reputation: 31

You have to format the output cell in date as well. Then you get the date instead of just numbers.

Upvotes: 0

Dmitry Pavliv
Dmitry Pavliv

Reputation: 35843

As I mentioned in comments above, you can use 

=DATE(2000,1,1)+165,728566

or write in A1 cell 1/1/2000 and in B1 cell =A1+165,728566

Upvotes: 0

KevinKSY
KevinKSY

Reputation: 31

You don't even need a function. You can just add the number of days to the starting date and the result is the the date after the number of days from the starting date.

Say in A1 cell you have the date : 01 Jan 2000. In A2 cell, input "A1 + 365". The result is 31 Dec 2000 since you have an additional day in February in 2000.

Upvotes: 2

Bathsheba
Bathsheba

Reputation: 234635

=DATEVALUE("01 Jan 2000") + 165, formatted as a date will give you the date that is 165 days from 01 Jan 2000.

Upvotes: 2

Related Questions