>I’ve checked online
2014年9月19日I’ve checked online, and all Cheap Jerseys for sale the calculators are for calculating the number of days between two dates.
Excel has a WORKDAY function, but also seems to be designed to figure out how many business days are between a specified start and end date.
What I need to find out is what the dates for the 9th and 20th business day are for each month for the rest of 2012 and for all of 2013. I’d prefer not to have to look off a calendar and do it wholesale jerseys manually.
posted by reenum to grab bag (6 answers total) 1 user marked this as a favorite
Why not just use the workday function for "last day of month previous, 9" and "last day of month previous, 20"?
So for January, you’d do =workday(31/12/2012,9), though it would be easiest just to have a column of "last day in month", one of workday 9, one of workday 20.
Excel has a WORKDAY function, but also seems to be designed to figure out how many business days are between a specified start and end date.
What I need to find out is what the dates for the 9th and 20th business day are for each month for the rest of 2012 and for all of 2013. I’d prefer not to have to look off a calendar and do it wholesale jerseys manually.
posted by reenum to grab bag (6 answers total) 1 user marked this as a favorite
Why not just use the workday function for "last day of month previous, 9" and "last day of month previous, 20"?
So for January, you’d do =workday(31/12/2012,9), though it would be easiest just to have a column of "last day in month", one of workday 9, one of workday 20.
コメント