What type formula to use?

[CE]

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

 

[Shane Devenshire]

Hi,

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

 

[CE]

Sorry.

On sheet 2 I have column a set up with names. B through AL have dates.

1 2 3 4 5 6 7 8 9 10 etc.
John Smith 8 8 8 8

The 8's represent the amount of time off taken.

On sheet 1 I have it set up similar.

June
Taken Total
John Smith 40

Under the Taken column is where I need the formula that adds the amount of
time off taken from the first of the month through the current date.

Sorry if my first post was a little too vague. Please let me know if you
need more info. to help me.

Thank you,
CE

 

[Jacob Skaria]

This should be COL B to AF ; right
Try the below formula in AG

=SUM(INDIRECT("B" & ROW() & ":" & ADDRESS(ROW(),DAY(TODAY())+1)))

If this post helps click Yes

 

[T. Valko]

Try this:

=SUM(Sheet2!B2:INDEX(Sheet2!B2:AF2,DAY(NOW())))

 

[CE]

THANK YOU!!!

Try this:

=SUM(Sheet2!B2:INDEX(Sheet2!B2:AF2,DAY(NOW())))

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

THANK YOU!!!