Dear Sir, I wanted to apply today formula by replace the manual date. like = "Outstanding Statement for " & PROPER(B3) & " as on today"