| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find the previous Weekday (thursday)
How can I identify the previous Thursday given a date? For instance, if I have a date (08/08/2006) in cell A4 and I need to know what the date is for the previous Thursday (08/03/2006), what formula could identify that date? -- JimDandy ------------------------------------------------------------------------ JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578 View this thread: http://www.excelforum.com/showthread...hreadid=570418 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find the previous Weekday (thursday)
=A1+CHOOSE(WEEKDAY(A1),-3,-4,-5,-6,0,-1,-2)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "JimDandy" wrote in message ... How can I identify the previous Thursday given a date? For instance, if I have a date (08/08/2006) in cell A4 and I need to know what the date is for the previous Thursday (08/03/2006), what formula could identify that date? -- JimDandy ------------------------------------------------------------------------ JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578 View this thread: http://www.excelforum.com/showthread...hreadid=570418 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find the previous Weekday (thursday)
On Thu, 10 Aug 2006 12:25:44 -0400, JimDandy
wrote: How can I identify the previous Thursday given a date? For instance, if I have a date (08/08/2006) in cell A4 and I need to know what the date is for the previous Thursday (08/03/2006), what formula could identify that date? =A1-WEEKDAY(A1+2) --ron |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find the previous Weekday (thursday)
Another alternative.......just in case.... For a date in A1 This formula returns the previous Thursday (unless A1 is already a Thursday): B1: =+A1-MOD(WEEKDAY(A1)+2,7) Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=570418 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find the previous Weekday (thursday)
All these responses are very much appreciated. Thank you... -- JimDandy ------------------------------------------------------------------------ JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578 View this thread: http://www.excelforum.com/showthread...hreadid=570418 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find comment replace cell value | Excel Discussion (Misc queries) | |||
| Find largest alphanumeric value matching alpha criteria in databas | Excel Worksheet Functions | |||
| Find within Workbook. | Excel Discussion (Misc queries) | |||
| Find and replace of word causes change of font formatting | New Users to Excel | |||
| Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
Linear Mode
