I have the below file: 1,2,3,4,5,2015-10-13,7,8,2037-01-151,2,3,4,5,2015-09-05,7,8,2040-01-151,2,3,4,5,2015-09-15,7,8,2016-06-151,2,3,4,5,2015-10-13,7,8,2015-07-081,2,3,4,5,2015-11-02,7,8,2015-08-02Using awk, How can I check the number of days between two dates ($6 and $9)?For the last record, the result should be 90is it doable? Thanks ... 
Difference between dates by awk
bash;awk
From the question I assume you want to count all months as 30 days. In this case you don't need to use external tool (like date), just calculate number of days by yourself:awk -F'[,-]' '{print 360*($6-$11)+30*($7-$12)+($8-$13)}' file-7652-8770-2709590