Entering days in spreadsheet

D

Dennis1188

Column A has “Order Date†Column B has “Due Dateâ€. Is there a way for me to
enter a date in column A and have B automatically show the date four weeks
later?
 
N

Niek Otten

In B1: =A1+28

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Column A has "Order Date" Column B has "Due Date". Is there a way for me to
| enter a date in column A and have B automatically show the date four weeks
| later?
 
J

JE McGimpsey

ONe way:

Dates in XL are just integer offsets from a base date, so

A1: <order date>
B1: =A1+28

Format B1 as a date.
 
N

Niek Otten

Use the WORKDAY() function. Look in HELP for details.

If you get the #NAME error: Tools>Add-ins, check Analysis Toolpak

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Is there a way so it does not include the weekend?
|
| "Gary''s Student" wrote:
|
| > =A1+28
| > and format as date
| > --
| > Gary''s Student - gsnu200722
 
B

bj

if you want it to end up on a friday if you enter a weekend
=A1+28-if(weekday(a1)=7,1,if weekday(a1)=0,2,0)
if you want it to end up on the monday following the weekend two weeks away
=A1+28+if(weekday(a1)=7,2,if weekday(a1)=0,1,0)
 
Top