# 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

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

#### 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:

Replies
4
Views
231
Replies
29
Views
558
Replies
4
Views
114
Replies
4
Views
82
Replies
3
Views
59

1,127,573
Messages
5,625,593
Members
416,121
Latest member
MrBuzz

### 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