I am using a function that is estimating Dates that an event will occur..
Columns
A = Order date
B = Process Order Date
C = Payment process date
D = Ship Date
E = Delivery Date
These cells contain dates that have or will occur (Actual Dates filled in when they occur)
A2, B2, C2, D2, E2
Columns for Etimate
AA = Order date
AB = Process Order Date
AC = Payment process date
AD = Ship Date
AE = Delivery Date
These cells contain the Estimated date that an even will occur (Estimated Dates of occurrence Formula filled in)
AA2, AB2, AC2, AD2, AE2
Rows 2 - 1000 are each order
There is other calculations taking place doing Averages, Trends based on type of order and items ordered but I have that working so no need to
include that complex sheet. and thats the output on $Ax$2 that I add to the Future Process Order Date
Bookmarks