Hello all,

I am working on a excel file that that I would like the sums two dates sum and converted into seconds and then transfer the calculations to a .csv file. I received help on this forum a little while ago, however I am now having a bit of an issue with VBA code for my file.

In the attached file the line of code that was given to me:
.Range("C" & trm1).Formula = _
        "=IF('Request Guest'!D" & tr & "="""","""",MAX(0,'Request Guest'!D2-Brain!B$2)*86400)"
That should return the amount of seconds between the sum of time times Brain!B$2 (Today()) and 'Request Guest'!D3(Date entered by me on the request guest worksheet) *86400.

Everything works fine expect in the line of code from the attached worked sheet: 
.Range("C" & trm1).Formula = _
        "=IF('Request Guest'!D" & tr & "="""","""",MAX(0,'Request Guest'!D2-Brain!B$2)*86400)"
'Request Guest'!D2 in the formula MAX(0,'Request Guest'!D2-Brain!B$2)*86400) dose not update to the next cell value !D3, !D4, ect..
I have tried to rewrite the formula but either the new formula produces an error or dose not return the correct results.

I am not sure how to get this value to update correctly?

Any help is much appreciated!