Need a formula for a forcast

Copper Contributor

Hello, I need a formula to figure out a pace.  If I were going it on a calculator I would take total dollars, divided by number of dats lapsed in year, times 365.  $1,200,000/31*365=$5,266,666.

I need it to know how many days have lapsed so far when calculating... possible?

1 Reply

@LKinne wrote:

Hello, I need a formula to figure out a pace.  If I were going it on a calculator I would take total dollars, divided by number of dats lapsed in year, times 365.  $1,200,000/31*365=$5,266,666.

I need it to know how many days have lapsed so far when calculating... possible?


You may consider the formula "=Date(y2,m2,d2)-Date(y1,m1,d1)" in order to compute the number of dates. In case the initial date is today, "Date(y1,m1,d1)" can be simply replaced by "Today()".

 

Hope this is helpful.