Wow, I thought I tried that first thing, but must not have as it works great.
I also tried =today()-14 and that works too. Thanks!

Tom

"Pete_UK" wrote:

If your date (=TODAY() ) is in A1, then:

=A1-14

formatted as a date will give you the date 14 days earlier.

Hope this helps.

Pete

On Oct 12, 10:56 am, tommcbrny
wrote:
Hello,

I would like to specify a date range for a report where the end date is
today (using =TODAY() in this cell) and the start date is today minus 14 days
(or 10 working days).

My goal is to have both dates appear correctly in a report template.

I found reference to an EDATE function that works well to subtract months
from TODAY. Is there a similar function to subtract days, or if not is there
another way to do this?

Thanks,

Tom