fill values in a formula in one cell with value from another cell
I have a bunch of formulas that pull figures from another sheet based on a start and stop date. They work just great.
I am trying to keep from having to change the date over and over in all of the formulas for each week of each month by using "Helper" Cells. You put the desired date range in for each week one time and the formulas below are populated with these date values.
Attached is a screen shot of what I am trying to do. Anyone have an idea on the proper syntax for this?
Help Article Resources
Check out the Formula Handbook template!