cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
Highlighted
PNash
PNash
Occasional Contributor

Working Days

Mar 25, 2019 1:00 PM (772 views)

Hi;

 

Is there any way to have JMP calculate a formula in working days like the WORKDAY function Excel?  I.E. 3/22/2019 + 1 day would be 3/25/2019 and not 3/23/2019.

 

Thanks!

0 Kudos
Reply
1 ACCEPTED SOLUTION

Accepted Solutions
pmroz
Super User pmroz
Super User
Solution

Re: Working Days

Mar 26, 2019 5:12 AM (744 views)  |  Posted in reply to message from PNash 03-25-2019

This function will do the trick.  Takes two arguments: a date and the number of days to add (or subtract if negative)

workday = function({one_date, add_days}, {local new_date, dow},

	new_date = date increment(one_date, "Day", add_days);
	dow = day of week(new_date);
	if (dow == 7,	// Saturday
		new_date = date increment(new_date, "Day", 2);
		,
		dow == 1,	// Sunday
		new_date = date increment(new_date, "Day", 1);
	);
	new_date;
);
testdate = informat("3/22/2019", "m/d/y");
workday(testdate, 2);

Output from the log:

25Mar2019
Reply
1 REPLY 1
pmroz
Super User pmroz
Super User
Solution

Re: Working Days

Mar 26, 2019 5:12 AM (745 views)  |  Posted in reply to message from PNash 03-25-2019

This function will do the trick.  Takes two arguments: a date and the number of days to add (or subtract if negative)

workday = function({one_date, add_days}, {local new_date, dow},

	new_date = date increment(one_date, "Day", add_days);
	dow = day of week(new_date);
	if (dow == 7,	// Saturday
		new_date = date increment(new_date, "Day", 2);
		,
		dow == 1,	// Sunday
		new_date = date increment(new_date, "Day", 1);
	);
	new_date;
);
testdate = informat("3/22/2019", "m/d/y");
workday(testdate, 2);

Output from the log:

25Mar2019
Reply