Date function - need help

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

Hello -

I have a column that has a date in it and I would like to create a function
that will display the following Wednesday's date in the next column.

Is this possible? If so, can someone please tell me how to write the
function?

Thanks in advance. Any help is greatly appreciated!
 
If your dates are in column A, try this in B1 and copy down:

=IF(WEEKDAY(A6,1)<4,4-WEEKDAY(A6,1)+A6,IF(WEEKDAY(A6,1)=4,7+A6,11-WEEKDAY(A6,1)+A6))

HTH,
Jim
 
=A1+MOD(11-WEEKDAY(A1),7)
I have assumed that if the date is a Wednesday you will show that date, not
a week hence?
 
Hello -

I have a column that has a date in it and I would like to create a function
that will display the following Wednesday's date in the next column.

Is this possible? If so, can someone please tell me how to write the
function?

Thanks in advance. Any help is greatly appreciated!
Click to expand...

=A1+8-WEEKDAY(A1+4)

--ron
 
=A1+MOD(11-WEEKDAY(A1),7)
I have assumed that if the date is a Wednesday you will show that date, not
a week hence?
Click to expand...

WEEKDAY already does a MOD(n,7) function.

So if you make that assumption about NOT advancing a week if the date is a
Wednesday, simpler would be:

=A1+7-WEEKDAY(A1-4)

--ron
 
Hello -

I have a column that has a date in it and I would like to create a function
that will display the following Wednesday's date in the next column.

Is this possible? If so, can someone please tell me how to write the
function?

Thanks in advance. Any help is greatly appreciated!
Click to expand...

I am not sure what u want let take this example

A1 =11/march/2008 and if you want Tuesday in B1

Then The formula is =A1

Select the column
Go to Format
Then Cells
Numbers
Customs
Type DDD

Then Ok

Hopefully this will help You

Cheers
Hardeep Kanwar
 
Back
Top