Help with dates
 

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.

Help with dates
 

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

Tyro

wrote in message
...
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.

Help with dates
 

And of course, format the cell with the formula as a date.

Tyro

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

Tyro

wrote in message
...
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.

Help with dates
 

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

=Order!E4-7

" wrote:

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.

Help with dates
 

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

"Tyro" wrote in message
...
And of course, format the cell with the formula as a date.

Tyro

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

Tyro

wrote in message
...
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.

Help with dates
 

On Feb 19, 3:07*pm, "Tyro" wrote:
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

"Tyro" wrote in message

...



And of course, format the cell with the formula as a date.

Tyro

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

Tyro

wrote in message
....
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.- Hide quoted text -

- Show quoted text -

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

Help with dates
 

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

Tyro

wrote in message
...
On Feb 19, 3:07 pm, "Tyro" wrote:
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!!!