| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating Friday Date
I have dates listed in column A indicating the day an action wa performed. In column B I need to have the date in column A changed to Friday. If the date in column A is not a Friday, then the date in colum B needs to fall back to the previous Friday. For example, if the dat entered in column A is today, Monday August 7, then the date in colum B that I would be Friday August 4. Can anyone think of code (or formula) that can determine this and place the value in column B Currently I use vlookup to go to another sheet where all the possibl dates are listed with their respective Fridays, but this slows down th calculation worksheet as the file is quite large. Thanks for any help o suggestions -- chris4652 ----------------------------------------------------------------------- chris46521's Profile: http://www.excelforum.com/member.php...fo&userid=3590 View this thread: http://www.excelforum.com/showthread.php?threadid=56909 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If weekend date display previous Friday date | Excel Discussion (Misc queries) | |||
| Calculating and listing only Monday-Friday in a work schedule | Excel Discussion (Misc queries) | |||
| friday date | Excel Discussion (Misc queries) | |||
| How can I get a row to display the date of the last friday, and every friday before that? | Excel Programming | |||
| the date always friday | New Users to Excel | |||
![chris46521[_19_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
