I need to find a formula!!!!!

canchando

New Member
Joined
Apr 4, 2009
Messages
2
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:

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
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
Joined
May 15, 2003
Messages
29,536
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
Joined
Apr 4, 2009
Messages
2
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....

I hope this helps, please let me know if you need anymore information.

-Cass
 
Last edited:

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
If you follow the link beneath my sig you can post a shot of your sheet.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,270
Messages
5,600,637
Members
414,398
Latest member
dhune

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top