Here is my layout:

Cell d4 is the day of month manually entered
In columns DN2 through ER2 I have 1 - 31 for 31 days in the month
I have revenue numbers in DN4 through ER4
I want to match what I put in D4 for day of month with the day in row 2 (DN
to ER) and return a month to date value.

So if today is the 10th I would put 10 in D4. I want to return a value for
DN4:DW4.
If it were the 5th of the month I would put 5 in D4 and want the sum of
DN4:DR4.

Any suggestions?