| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Followinf Friday of a certain day
Thanks for the feedback :D
-- John C "Alfredo_CPA" wrote: Thanks John It works perfect P.S. for other members: the formula gives you the following Friday of that day (including the day itself ). If you don;t want to include the day itself then, please use Peo posting "John C" wrote: Doesn't quite work, if A5 is a Saturday. =A5+7-(WEEKDAY(A5+1)) -- John C "Bob Phillips" wrote: =A1+6-WEEKDAY(A1) -- __________________________________ HTH Bob "Alfredo_CPA" .(donotspam) wrote in message ... I have in cell "A5" one day of the month I need a formula in "A6" that gives me the following friday of that specific day based on the input on "A5" Any ideas?? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| friday date | Excel Discussion (Misc queries) | |||
| Second Friday | Excel Worksheet Functions | |||
| 3rd Friday every month | Excel Discussion (Misc queries) | |||
| Friday | New Users to Excel | |||
| Finding Friday | Excel Discussion (Misc queries) | |||
![John C[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
