Date Add 26 weeks minus 1 day

[ker9]

Hi,
I need to add 26 weeks to a date and then subtract 1 day from it:

This adds 26 weeks but I'm at a total loss as to how to subtract 1 day from it. Can it be done in one formula? (I can do it in a 2nd formula referencing this, but would love to get it into one formula.)

 
(DateAdd("ww",26,[dte]))

Thank you.

[RuralGuy]

Try: (DateAdd("ww",26,[dte])-1)

[ker9]

Thank you - clearly I was way over thinking this

[RuralGuy]

Maybe a better understanding of the DateTime field would be helpful for the future. http://support.microsoft.com/kb/q130514/en-us