Re: Correcting AGE_INFO
Re: Correcting AGE_INFO
- Subject: Re: Correcting AGE_INFO
- From: Doug McNutt <email@hidden>
- Date: Thu, 4 Feb 2010 11:33:52 -0700
At 09:56 -0800 2/4/10, email@hidden wrote:
Here are two more possible solutions:
which I snipped.
If you have, for other reasons, an AppleScriptable version of Microsoft Excel on your mac there is a NETWORKDAYS( ) function that does pretty much what you want.
--quoting--
NETWORKDAYS(start_date,end_date,holidays)
Start_date is a date that represents the start date. Dates may be entered as text strings within quotation marks (for example, "1/30/1998" or "1998/01/30"), as serial numbers (for example, 34363, which represents January 30, 1998, if you're using the 1904 date system), or as results of other formulas or functions (for example, DATEVALUE("1/30/1998")).
End_date is a date that represents the end date.
Holidays is an optional range of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays. The list can be either a range of cells that contain the dates or an array constant of the serial numbers that represent the dates. Learn about array constants.
--
-> The US of A is getting pelloreid <-
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden