Calculate Start Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
Click to expand...

Excel stores dates as days since 1/1/1900 (or 1904).

So with your date in A1, to subtract 14 days, the formula would be:

=A1-14

If you want to subtract just working days, look at HELP for the WORKDAY
function.

=WORKDAY(A1,-10)


--ron
 
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
 
You're welcome - thanks for feeding back.

Pete

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






- Show quoted text -
Click to expand...
 
Back
Top