| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get next working day
On Sat, 31 Jan 2009 13:42:49 -0800 (PST), Savio wrote:
How can i write a formula to enter the following Monday's date if the current day is a saturday or a sunday? It would be preferable to get this in one formula Thanks Try =WORKDAY(A1,1) If you get a #NAME! error, see HELP for the function for how to resolve. --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate working days but change working week | Excel Discussion (Misc queries) | |||
| Making weekend days working days - the system cuts the working tim | Excel Discussion (Misc queries) | |||
| Not working HELP | Excel Discussion (Misc queries) | |||
| working | Excel Worksheet Functions | |||
| Working out UK tax | New Users to Excel | |||
Hybrid Mode
