Get Last working day of the month

manmarirama · #1 (**permalink**) 06-03-2008

Hi

I need a script to get "Last working day of the month". I will pass the month and year as parameters and i need to get the last working date.

Ex
for June 2008 the last working day is 30th its monday.
for August 2008 the last working day is 29th and it is Friday.

ie the last working day falls in Monday to Friday.

Thanks for the help.

era · #2 (**permalink**) 06-03-2008

The only useful Google result I could find was this, but then, it's actually pretty useful. Scroll down to the end for the grande finale. crontab(s) for the last "work-day" of every month [Archive] - The macosxhints Forums

manmarirama · #3 (**permalink**) 06-03-2008

Thanks a lot but i tried that code its going into infinite loop.

awk · #4 (**permalink**) 06-03-2008

I would try something like this:

Code:

cal | awk '/^.[0-9]/{nf=NF;Date=$NF}
END{print nf, Date}'
2 30

you will need to modify the END logic, but basically
if nf is between 2 and 6 (representing Monday thru Friday), there is your end of month.

if nf is 1 or 7, that represents Sunday and Saturday, respectively, so adjust the Date according.

Should be a snap.

matt.d · #5 (**permalink**) 06-03-2008

Edit: My code is garbage....go with the above post.

danmero · #6 (**permalink**) 06-03-2008

Quote:

Originally Posted by manmarirama

for August 2008 the last working day is 29th and it is Friday.

This will do the job.

Code:

cal 8 2008 | awk '{ if(NF>1) a=$NF ; if (NF==7) a=$6}END{print a}'

ripat · #7 (**permalink**) 06-04-2008

With GNU date (coreutils) and bash:

Code:

#!/bin/bash 

export LC_ALL=C
m=$(($1+1))
i=1
lastwday=$(date "+%w" --date "2008/$m/01 -$i days")
while [[ "$lastwday"  < 1 ]] || [[ "$lastwday" > 5 ]];do
        ((i++))
        lastwday=$(date "+%w" --date "2008/$m/01 -$i days")
done

dtelastwday=$(date --date "2008/$m/01 -$i days")

echo "The last working day of 2008/$1 is $dtelastwday"
exit 0

Code:

$ script-name 8
> The last working day of 2008/8 is Fri Aug 29 00:00:00 CEST 2008

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Capture of month	Rafael.Buria	Shell Programming and Scripting	2	01-10-2008 07:44 AM
How to match month	Nayanajith	Shell Programming and Scripting	1	06-27-2006 01:55 AM
The last day of the last month	emily79	Shell Programming and Scripting	2	09-09-2005 09:54 AM
last day of the month	aya_r	Shell Programming and Scripting	4	08-23-2005 12:26 AM
Write a shell script to find whether the first day of the month is a working day	phani	Shell Programming and Scripting	7	03-18-2005 01:59 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by