I need to use data based on the day of the month not based on the numbers i have entered.

i have a workbook that uses days of the month to analyze data, but i would like it to only analyze data for the days leading up to and including the current day. is there a function for this?

For example, if i enter in $125 in column 5 on "sheet 1" for every Wednesday of March. (this is a recurring expense)

then i enter the total daily sales in column 2 in "sheet 1" (this obviously changes daily)

on "sheet 2" of the workbook i take the total of column 5 and divide it by the total of column 2 to create a percentage of cost

I would like the formula on "sheet 2" to only use the data for the days leading up to and including today.

there are several different columns of data in "sheet 1" that get calculated in "sheet 2" to create percentages for my analysis, this is just one example and if i can figure out one of them, i can use the same for all columns.

I hope someone can understand my problem and offer a solution.

thank you

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Hi,

You may get a better response if you upload your workbook, or at least a representative sub set of it.
Add some manually calculated results and some notes that clearly identify the results cells and what rules you applied to arrive at them.

As they say, a picture is worth a thousand words and from my experience people prefer to know exactly what they are dealing with and prefer not to have to interpret a narrative description, which they often find is not what the poster wanted. Some questions may be simple enough that just a narrative is all that's needed, but your request I suggest is not in this category.