Advanced Search

Question: How can I get the date

Question:How can I get the date

brian bovril 889 Maple 2017
date
September 06 2017
0

Hello

There are 13214 days between these two dates.

with(Finance): DayCount("Jan-01-1981", "MAR-7-2017");

But how can I find the end date, given the beginning date and the days between?

This doesn't work (of course, because the date is not a number):

fsolve(DayCount("Jan-01-1981", x)=13214)

is there a direct way? in excel i would do it indirectly using Goal Seek
Please Wait...