**Current Formula - Working**

=IF(DATEDIF(TODAY(),U6,"d") > 7,ROUNDDOWN(DATEDIF(TODAY(),U6,"d")/7,0)&IF(ROUNDDOWN(DATEDIF(TODAY(),U6,"d")/7,0) > 1," Weeks and "," Week and ")&DATEDIF(TODAY(),U6,"d")-(ROUNDDOWN(DATEDIF(TODAY(),U6,"d")/7,0)*7)&IF(DATEDIF(TODAY(),U6,"d")-(ROUNDDOWN(DATEDIF(TODAY(),U6,"d")/7,0)*7) > 1," days"," day"),IF(DATEDIF(TODAY(),U6,"d") = 1,"Tomorrow",DATEDIF(TODAY(),U6,"d")&IF(DATEDIF(TODAY(),U6,"d") > 1," days"," day")))

**New Formula - Broken**

=IF(DATEDIF(TODAY(),U6,"d") > 7,IF(DATEDIF(TODAY(),U6,"d")/7 = 2,"Today",ROUNDDOWN(DATEDIF(TODAY(),U6,"d")/7,0)&IF(ROUNDDOWN(DATEDIF(TODAY(),U6,"d")/7,0) > 1," Weeks and "," Week and ")&DATEDIF(TODAY(),U6,"d")-(ROUNDDOWN(DATEDIF(TODAY(),U6,"d")/7,0)*7)&IF(DATEDIF(TODAY(),U6,"d")-(ROUNDDOWN(DATEDIF(TODAY(),U6,"d")/7,0)*7) > 1,"days","day"),),IF(DATEDIF(TODAY(),U6,"d") = 1,"Tomorrow",DATEDIF(TODAY(),U6,"d")&IF(DATEDIF(TODAY(),U6,"d") > 1," days"," day")))

## What I'm Trying To Add

I've got "Tomorrow" working, however now I wish to implement a "Today". To work out if it is "Today", I add the length between the payments as it jumps to the next date if it is today, or in my above version, I go for the weeks between method.

I've broken up my function several times, however I cannot see the problem. Is there a limit to the length of a formula maybe?

`"days","day"),),`

to`"days","day")),`

;). – shA.t Jan 18 '17 at 11:17