Forum Discussion
Need a formula for a forcast
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 ne...
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.