| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get next working day
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Get next working day
Try,
=A1+CHOOSE(WEEKDAY(A1),1,0,0,0,0,0,2) Mike "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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Get next working day
An alternative =A1-WEEKDAY(A1,3)+7 -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.thecodecage.com/forumz/member.php?userid=111 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=57111 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Get next working day
the OP only wanted Monday if the date was a sat or sun not next monday in all
instances "oldchippy" wrote: An alternative =A1-WEEKDAY(A1,3)+7 -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.thecodecage.com/forumz/member.php?userid=111 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=57111 |
|
#5
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Get next working day
Suppose there is current date in A1 then to insert following Mondays date
based on current date, follow following steps 1.Select cell B1 right click formate cells number tabselect date from category list select 03/14/01 from type list 2.Now insert following formula in cell B1 =DATE(YEAR(A1),MONTH(A1),DAY(A1)+IF(WEEKDAY(A1)=1, 1,IF(WEEKDAY(A1)=2,0,IF (WEEKDAY(A1)=3,6,IF(WEEKDAY(A1)=4,5,IF(WEEKDAY(A1) =5,4,IF(WEEKDAY(A1)=6,3))))) )) Now you get it ! Have a nice day Chris ------ Convert your Excel spreadsheet into an online calculator. http://www.spreadsheetconverter.com -- Message posted via http://www.officekb.com |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Get next working day
Mike H;208154 Wrote: the OP only wanted Monday if the date was a sat or sun not next monday in all instances "oldchippy" wrote: An alternative =A1-WEEKDAY(A1,3)+7 -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: 'The Code Cage Forums - View Profile: oldchippy' (http://www.thecodecage.com/forumz/member.php?userid=111) View this thread: 'Get next working day - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...ad.php?t=57111) Sorry about that - my first post here, I was to keen to get started ;) -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.thecodecage.com/forumz/member.php?userid=111 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=57111 |
| 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 | |||
Linear Mode
