Auto Date Population

[theboatdude]

Hello Everyone -

Here's what it is: I use an Excel-based form to order product. What
want is to set up a chosen cell to show the date of the followin
Tuesday, regardless of when I fill out the form (for instance, if
were to fill out the form today - 7/20/04 - I would want the chose
cell to read the date for the following Tuesday - 7/27/04.

Under different circumstances, I would simply enter a formula to sho
the date X days from today, but I don't always place the order on th
same day.

Can this be done?

Thankx,

C

 

[Frank Kabel]

Hi
for your first question use the formula
=A1+7-WEEKDAY(A1-1,3)

For the second question simply add x to your date. e.g.
=A1+X

If you only want to add working days use
=WORKDAY(A1,X)

 

[Bernie Deitrick]

CT,

For a date in cell A1:

=IF(WEEKDAY(A1)<3,INT(A1+3-WEEKDAY(A1)),INT(A1+10-WEEKDAY(A1)))

HTH,
Bernie
MS Excel MVP