Hi,

Why don't you show us a sample of your data layout and what you want.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"CE" wrote:

Hi,

I need a formula that takes into account todays date before it adds the row
range.

The spreadsheet I'm working with has 2 tabs. On the second tab are the rows
I need added: B2:AL2
For this to show what is needed I need it to only display a number through
the current date. So using the current date the 9th - I won't want to add the
rest of the month. Is this possible?

If not what formula can I use that only adds within the row and displays the
amount added once something is inputted into the row?

Sorry if this is a little strange. Thank you for your help :)