Possesion Dates

  • Thread starter Thread starter Slim
  • Start date Start date
S

Slim

I have a table created
A B C D E F G
1 Jan Feb Mar Apr May June July
2 3 1 1 1 2 1 1
3
4

Row 2 is the number of homes sold. If it takes 'X' months
to build a home I need a formula to calculate how many
homes are under construction in that month on row 3 and a
fomula to tell me how many homes will be completed in that
month on row 4.

Any ideas?

Thanks!
Slim
 
It would seem to be important to know the Start_Date to determine
Completion_Date after x Number of Days.

=Start_Date+X Days

where X is the number of workdays required.

Therefore, It appears you need to enter an actual start date instead of Jan
or Feb, which opens a large timeframe and is not amenable to calculation.
 
Back
Top