| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another Working day question!
Hello, I have two cells A1 and B1, in A1 I have a date. In B1 I want that date 5 working days later (Monday to Friday). Is this possible in 1 formula? Thank you for your time. ;) -- neway9 ------------------------------------------------------------------------ neway9's Profile: http://www.excelforum.com/member.php...o&userid=17622 View this thread: http://www.excelforum.com/showthread...hreadid=560174 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Another Working day question!
Just add 5 in cell B1 (=a1+5) and drag the formula -- blissworks ------------------------------------------------------------------------ blissworks's Profile: http://www.excelforum.com/member.php...o&userid=36156 View this thread: http://www.excelforum.com/showthread...hreadid=560174 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Another Working day question!
Hello, Yeah, got that, but need it to be working days only. -- neway9 ------------------------------------------------------------------------ neway9's Profile: http://www.excelforum.com/member.php...o&userid=17622 View this thread: http://www.excelforum.com/showthread...hreadid=560174 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Another Working day question!
Hi neway9, Will this work? = WORKDAY(A1,4) -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=560174 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Another Working day question!
Yeah, that works great, Thank you! -- neway9 ------------------------------------------------------------------------ neway9's Profile: http://www.excelforum.com/member.php...o&userid=17622 View this thread: http://www.excelforum.com/showthread...hreadid=560174 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Graph from a PIVOT table: update not working. Please Help! | Excel Discussion (Misc queries) | |||
| Working time and days | Excel Worksheet Functions | |||
| Working time and days | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| Trace Dependents and Precedents not working | Excel Worksheet Functions | |||
Linear Mode
