| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
friday date
On Mon, 18 Feb 2008 05:58:03 -0800, deepika :excel help
wrote: i tried it worked for weekdays yes. when im on a saturday say(16 th feb) it has to show 22nd feb (friday) but it shows the prev friday(15 feb).. any day after a friday it shud show the next friday. Also is it meaningful to havea code for this inside a macro.. teh reason is taht whenever i open that cell should giveme friday date =A1+7-(WEEKDAY(A1+1)) or substitute TODAY() for A1 in the formula. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate the friday before a date? | Excel Discussion (Misc queries) | |||
| Friday date of next week.. | Excel Discussion (Misc queries) | |||
| How do I get the date for the 2nd friday of each month? | Excel Worksheet Functions | |||
| the date always friday | New Users to Excel | |||
| date of last friday of previous month | Excel Discussion (Misc queries) | |||
Hybrid Mode
