I want to find a date that is 57 –working– days after an arbitrary date using date or bash. For instance,
- today is august 21st,
- reference date is july 15th,
- what days will be 57 working days after july 15th?
Asked
Active
Viewed 397 times
0
Édouard Lopez
- 40,270
- 28
- 126
- 178
-
1Define "working days" in this context? Weekdays? – Etan Reisner Aug 21 '14 at 16:25
-
4`date -d '7/15/14 +57 days'` would work for regular days. Getting working days would require doing some extra math. – Reinstate Monica Please Aug 21 '14 at 16:32
-
This might be better solved in python. See: http://stackoverflow.com/questions/2224742/business-days-in-python – carl.anderson Aug 21 '14 at 18:23
-
@EtanReisner working days should exclude week-ends and French's holidays – Édouard Lopez Aug 22 '14 at 07:45
2 Answers
2
This should work to just get all days
date -d '7/15/14 +57 days'
To get number of work days (M..F) you can do something lazy like this
#!/bin/bash
days=0
for ((i=1;i>0;i++)) do
future=$(date -d "7/15/14 +$i days" '+%w')
((future!=0 && future!=6)) && ((days++)) # ignore sunday (0) and saturday (6)
((days==57)) && date -d "7/15/14 +$i days" && break
done
e.g.
> ./abovescript
> Thu Oct 2 00:00:00 CDT 2014
Édouard Lopez
- 40,270
- 28
- 126
- 178
Reinstate Monica Please
- 11,123
- 3
- 27
- 48
0
Weird solution:
day=21
mon=8
year=2014
days=4
curl -s "http://www.timeanddate.com/scripts/dateserver.php?mode=addweekdays&d1=$day&m1=$mon&y1=$year&type=add&ad=$days&atyp=0&ach=3" | sed -n 's|.*<h2>Result: \(.*\)</h2>.*|\1|p'
prints
Wednesday, August 27, 2014
the date after 4 working days from 2014.08.21
for the
day=15
mon=7
year=2014
days=57
prints
Friday, October 3, 2014
clt60
- 62,119
- 17
- 107
- 194