Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date function - need help
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date function - need help
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 "Ann" wrote: 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date function - need help
With dates in column A:
=A1+CHOOSE(WEEKDAY(A1),3,2,1,7,6,5,4,3,2,1) -- Gary''s Student - gsnu2007f "Ann" wrote: 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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date function - need help
=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? -- David Biddulph "Ann" wrote in message ... 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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date function - need help
On Mon, 10 Mar 2008 15:38:01 -0700, Ann wrote:
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! =A1+8-WEEKDAY(A1+4) --ron |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date function - need help
On Mon, 10 Mar 2008 23:05:44 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote: =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? -- David Biddulph 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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date function - need help
Yes, that makes sense. I thought there must be an easier way. :-)
-- David Biddulph "Ron Rosenfeld" wrote in message ... 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) On Mon, 10 Mar 2008 23:05:44 -0000, "David Biddulph" <groups [at] biddulph.org.uk wrote: =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? -- David Biddulph |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date function - need help
On Mar 11, 3:38 am, Ann wrote:
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! 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date function in ACCRINTM requires date format not available | Excel Worksheet Functions | |||
MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions |