# I need to find a formula!!!!!

#### canchando

##### New Member
I have a site tracker, with different tabs, of all the sites i currently track. I have a summary tab that adds up certain completion dates for each site. I need to find a formula that will show me (on my summary sheet) how many sites i have forecasted for the week-every single week, without me having to change it.

Any help is greatly appreciated!!

Last edited:

### Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

#### nbrcrunch

##### Well-known Member
welcome to the board.

However, how can we recommend a formula when you've not given us any specifics of sheet names, where the data is (columns & rows), what needs to be added to what, and so on.

#### Smitty

##### Legend
Welcome to the Board!

You'll need to give some more details. How about an example of what you have and what you want?

Check out the link beneath my sig for how to post a shot of your sheet.

#### canchando

##### New Member
I will try my best to explain.

I have a tracker that tracks certain milestones, the first tab in that tracker is a summary page. it adds up the number of actual dates I have. What I am looking for is a formula for my forecasted construction start dates. (in the different tabs, there is a construction start column, and under it has "forecast" and "actual." I want to be able to open my tracker on monday, and have the summary page show me how many sites i have forecasted for that week, until sunday @ midnight, when it starts calculating that week, and so on....

-Cass

Last edited:

#### Smitty

##### Legend

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,657
Messages
5,838,635
Members
430,558
Latest member
Krampus

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back