| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!!! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
| Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
| Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel | |||
Linear Mode
