| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Week Ended Friday
Hi
Could anyone help me that I am writing a formula the allow me to bring the date onto week ended Friday, for example cell A1=3 Sep 07 (Monday) cell B1 (where the formula will be) wil show me a result 7 Sep 07 (Friday) and/or A1=7 Sep 07 (Monday) cell B1 will also show me the result 7 Sep 07 (Friday). I use vlookup on it doesn't work especailly the date on Friday. Please help. Thank you. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Week Ended Friday
Give this formula a try...
=A1+6-WEEKDAY(A1) Rick Could anyone help me that I am writing a formula the allow me to bring the date onto week ended Friday, for example cell A1=3 Sep 07 (Monday) cell B1 (where the formula will be) wil show me a result 7 Sep 07 (Friday) and/or A1=7 Sep 07 (Monday) cell B1 will also show me the result 7 Sep 07 (Friday). I use vlookup on it doesn't work especailly the date on Friday. Please help. Thank you. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Week Ended Friday
Thank you so much Rick. It works perfectly
"Rick Rothstein (MVP - VB)" wrote: Give this formula a try... =A1+6-WEEKDAY(A1) Rick Could anyone help me that I am writing a formula the allow me to bring the date onto week ended Friday, for example cell A1=3 Sep 07 (Monday) cell B1 (where the formula will be) wil show me a result 7 Sep 07 (Friday) and/or A1=7 Sep 07 (Monday) cell B1 will also show me the result 7 Sep 07 (Friday). I use vlookup on it doesn't work especailly the date on Friday. Please help. Thank you. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Week Ended Friday
On Thu, 20 Sep 2007 02:00:20 -0400, "Rick Rothstein \(MVP - VB\)"
wrote: Give this formula a try... =A1+6-WEEKDAY(A1) Rick Could anyone help me that I am writing a formula the allow me to bring the date onto week ended Friday, for example cell A1=3 Sep 07 (Monday) cell B1 (where the formula will be) wil show me a result 7 Sep 07 (Friday) and/or A1=7 Sep 07 (Monday) cell B1 will also show me the result 7 Sep 07 (Friday). I use vlookup on it doesn't work especailly the date on Friday. Please help. Thank you. I'm not sure if it's what the OP wants, but your formula: Saturday, Sep 01, 2007 -- Friday, Aug 31, 2007 Whereas =A1+7-WEEKDAY(A1-6) Saturday, Sep 01, 2007 -- Friday, Sep 07, 2007 --ron |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Week Ended Friday
Give this formula a try...
=A1+6-WEEKDAY(A1) Rick Could anyone help me that I am writing a formula the allow me to bring the date onto week ended Friday, for example cell A1=3 Sep 07 (Monday) cell B1 (where the formula will be) wil show me a result 7 Sep 07 (Friday) and/or A1=7 Sep 07 (Monday) cell B1 will also show me the result 7 Sep 07 (Friday). I use vlookup on it doesn't work especailly the date on Friday. Please help. Thank you. I'm not sure if it's what the OP wants, but your formula: Saturday, Sep 01, 2007 -- Friday, Aug 31, 2007 Whereas =A1+7-WEEKDAY(A1-6) Saturday, Sep 01, 2007 -- Friday, Sep 07, 2007 That's a fair point. My impression when I first read the OP's post was that his dates where weekdays only (no weekends), but that is only a gut-feeling. Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trial ended after 4-5 days | New Users to Excel | |||
| Finding Friday in week number | New Users to Excel | |||
| Need open ended cell for Sum range. | Excel Worksheet Functions | |||
| open ended multi page sum | Excel Worksheet Functions | |||
| open ended multi page sum | Excel Worksheet Functions | |||
Linear Mode
