How do I make a self referencing simple subtraction equation?
So I am working on a spreadsheet that tracks payments made by clients with amount due, amount paid, and any late fees incurred. 

My formula currently is 

    =(B5-B6)+B8

The problem is, I have hundreds of other cells in that row, but different columns, that all need that formula, But I am forced to manually type the column letter each time. 

    =(C5-C6)+C8
    =(D5-D6)+D8
    =(E5-E6)+E8
    =(F5-F6)+F8
    =(G5-G6)+G8

Etc.

I was wondering if there was a way that I could make one formula that self references its own column, one that I could use without having to change the column letter with a self referencing variable looking like =(CurrentColumn5-CurrentColumn6)+CorrentColumn8.
How do I make a self referencing simple subtraction equation?
===

So I am working on a spreadsheet that tracks payments made by clients with amount due, amount paid, and any late fees incurred. 

My formula currently is 

    =(B5-B6)+B8

The problem is, I have hundreds of other cells in that row, but different columns, that all need that formula, But I am forced to manually type the column letter each time. 

    =(C5-C6)+C8
    =(D5-D6)+D8
    =(E5-E6)+E8
    =(F5-F6)+F8
    =(G5-G6)+G8

Etc.

I was wondering if there was a way that I could make one formula that self references its own column, one that I could use without having to change the column letter with a self referencing variable looking like =(CurrentColumn5-CurrentColumn6)+CorrentColumn8.