Office Mags->Excel Help- Selecting A Discontiguous Range for a function

Having Trouble with the following

I'm trying to use the XIRR Function to calculate Internal Rate of Return

the function is formulated like this-> =XIRR(values,dates)

I can use this fine if the Data and dates are continuous. For example =XIRR(B4:H4,B3:H3)



I am having problems excluding a cell from the contiguous data range though- I don't want to include column G, so I have tried to formulate it like this ->

=XIRR((B4:F4,H4),(B3:F3,H3))

I keep getting error messages. I know to press control and then select again for normal excel functions like =SUM, but this is not working.

Any insight greatly appreciated. Thanks