Dave,

You only need to use the concatenators where you're substituting the
variable lPrevSumRow for the row number.

Try this (all on one line)...

"=IF(G" & lprevsumrow & "<"""",DATEDIF(G" & lprevsumrow & ",H" &
lprevsumrow & ",""d"")+1,"""")"

NickH