Help with dates

[djohns158]

I am using Excel 2007 for generating purchase orders. The shipping
date from the vendor needs to be 7 days prior to the shipping date to
the customer. The customer's shipping date is in Order! E4. Can
anybody help me with the formula which will automatically look at the
shipping date in Order! E4, subtract 7 days, then put the new date in
the desired cell? Your help is greatly appreciated. Thank you.

 

[Tyro]

Dates are numbers in Excel. To obtain a date 7 days earlier, it's just
=Order!E4-7

Tyro

 

[Joel]

You need to subtract 7 from the date and make sure the destination cell is
formated as a date

=Order!E4-7

 

[Tyro]

If you need to deal with workdays, excluding weekends and holidays, you can
use the WORKDAY function. If your date is in A1 then =WORKDAY(A1,-7)
returns the date of the workday 7 days earlier. The WORKDAY function
requires installation of the Analysis Toolpak in versions of Excel 2007. It
is present in Excel 2007.

Tyro

 

[djohns158]

If you need to deal with workdays, excluding weekends and holidays, you can
use the WORKDAY function.  If your date is in A1 then =WORKDAY(A1,-7)
returns the date of the workday 7 days earlier. The WORKDAY function
requires installation of the Analysis Toolpak in versions of Excel 2007. It
is present in Excel 2007.

Tyro






- Show quoted text -

Worked like a charm!!!!! Thank you so much.... I didn't know about
the Workday function.... AWESOME!!! Again, thank you!!!

 

[Tyro]

To exclude holidays from the computation, you have to provide the dates of
the holidays. See help on WORKDAY

Tyro

If you need to deal with workdays, excluding weekends and holidays, you
can
use the WORKDAY function. If your date is in A1 then =WORKDAY(A1,-7)
returns the date of the workday 7 days earlier. The WORKDAY function
requires installation of the Analysis Toolpak in versions of Excel 2007.
It
is present in Excel 2007.

Tyro

Worked like a charm!!!!! Thank you so much.... I didn't know about
the Workday function.... AWESOME!!! Again, thank you!!!