15块钱找人做一个Excel基础Function题目基本要求8元，Bonus7元（看达到bonus要求程度），实在没时间做，只好找人。做完后请发电邮和做好的worksheet到 pgppuppy@hotmail.com 注明你的电话号和银行户头号码。若不放心也可先给我发email，再电话联系，或在华新回信息。验证所有要求达到后立刻转帐，非先做先得，乃先做对先得，谢谢！
U r required to compile a bill payment calendar.
Requirement
When a date is entered e.g 1/27/2007 The bill payment dates should all be automatically calculated under the “Date” column
Rules for the date
Rule 1. e.g. 1 Month—the date should be 1 month after the date entered (as shown by the simple example 1/27/2007 one month is 2/27/2007 in the sheet)
Rule2 if the date entered is the last day of the month, the calculated date should also be the last day of the month provided it is a working day.
E.g 1/31/2007 one month is 2/28/2007. (provided 2/28 is working day)
2/28/2007 one month is 4/30/2007 (provided 4/30 is working day)
Rule3 If the calculated date based on rule1 and rule2 is a non-working day, the date is pushed back by 1 till it becomes a working day.
e.g 1/27/2007 two month is 3/27/2007 if 3/27/2007 is Saturday it becomes 3/28/2007 which is a Sunday, another non-working day. So the output should be 3/29/2007
Rule4, under rule3, the date cannot be pushed to the next month. Instead, we push the date forward. In the previous example assume 3/29, 3/30 and 3/31 are all public holidays, by rule3, it will be finally pushed to 4/1. But this becomes another month. So we push forward instead to 3/26 which is Friday. The output is 3/26/2007
Definition of working dates (Monday to Friday excluding the holidays listed in the sheet)
Important Note
1. Date functions are available only if the Analysis ToolPak add-in program is installed. If the add-in is not installed, you may see the #NAME? error value. To find out if the add-in is installed, on the Tools menu, click Add-Ins. Analysis ToolPak and Analysis ToolPak VBA and should have a check mark in the box beside it. If it doesn't, just click to select that box, click OK, and follow instructions.
2. Remember to format cells as dates
3. You can use excel functions and/or macro to achieve the output. However, bonus will be given to those without using macro.
Additional Bonus Work
You are strongly encouraged to check out the holiday dates of 2008, 2009…2015 inline with those listed in 2007, and you can incorporate them into the worksheet. You can also increase the number of months to a maximum of 24 months for the ultimate bonus.
Work Sheet Download Address
http://www.wikiupload.com/download_page.php?id=63818
click "Download" on the write. Enter verification code shown and press "Get"
[askist (1-27 17:44, Long long ago)]
[ 传统版 |
sForum ][登录后回复]1楼
也可先加我msn,若在保证output非常准确的情况下Function很简明 还可再提高价钱[askist (1-27 17:59, Long long ago)] [ 传统版 | sForum ][登录后回复]2楼
(引用 askist:也可先加我msn,若在保证output非常准确的情况下Function很简明 还可再提高价钱)注：此非NUS Tutorial题目，,不涉及任何问题[askist (1-27 18:01, Long long ago)] [ 传统版 | sForum ][登录后回复]3楼
(引用 askist:注：此非NUS Tutorial题目，,不涉及任何问题)我的msnpgppuppy@hotmail.com 谢谢![askist (1-27 18:01, Long long ago)] [ 传统版 | sForum ][登录后回复]4楼
。。。这么少的钱，有人做吗[官管 (1-27 19:20, Long long ago)] [ 传统版 | sForum ][登录后回复]5楼
(引用 官管:。。。这么少的钱，有人做吗)会用date function的几行就可完成，完成一个其他的全是copy&paste,[askist (1-27 19:50, Long long ago)] [ 传统版 | sForum ][登录后回复]6楼
(引用 官管:。。。这么少的钱，有人做吗)anyway明天还没做成的话不介意加钱,到时再说[askist (1-27 19:51, Long long ago)] [ 传统版 | sForum ][登录后回复]7楼
报酬增加到$30 基本功能$20 Bonus功能$10[askist (1-27 20:53, Long long ago)] [ 传统版 | sForum ][登录后回复]8楼
报酬增加到$30 基本功能$20 Bonus功能$10[askist (1-27 20:53, Long long ago)] [ 传统版 | sForum ][登录后回复]9楼
最终价$50,基本35,Bonus15. 解出后附加送一个比$50更有价值的信息，跟此题的答案有关[askist (1-28 10:16, Long long ago)] [ 传统版 | sForum ][登录后回复]10楼
(引用 askist:最终价$50,基本35,Bonus15. 解出后附加送一个比$50更有价值的信息，跟此题的答案有关)时限为今晚11点前 谢谢[askist (1-28 10:32, Long long ago)] [ 传统版 | sForum ][登录后回复]11楼
(引用 askist:时限为今晚11点前 谢谢)才50？倒一个先[〓▇▇● (1-28 12:27, Long long ago)] [ 传统版 | sForum ][登录后回复]12楼
(引用 〓▇▇●:才50？倒一个先)I am asking for solution, not opinion. 听不懂一边凉快去[askist (1-28 13:04, Long long ago)] [ 传统版 | sForum ][登录后回复]13楼
(引用 〓▇▇●:才50？倒一个先)还没有开枪呢..[▄︻┻┳═一 (1-28 14:56, Long long ago)] [ 传统版 | sForum ][登录后回复]14楼
(引用 askist:I am asking for solution, not opinion. 听不懂一边凉快去)solution？倒一个先[〓▇▇● (1-28 14:58, Long long ago)] [ 传统版 | sForum ][登录后回复]15楼
(引用 ▄︻┻┳═一:还没有开枪呢..)omg[〓▇▇● (1-28 15:06, Long long ago)] [ 传统版 | sForum ][登录后回复]16楼
已经解出，谢谢支持！[askist (1-28 18:03, Long long ago)] [ 传统版 | sForum ][登录后回复]17楼
(引用 askist:已经解出，谢谢支持！)做出来的那位大牛能不能指导一下怎么在vba里面调用excel非worksheetfunction的其他内置函数？如EDATE之类的。
谢谢！
尝试做来着，不过不会 ：P[havfrue (1-28 22:54, Long long ago)]
[ 传统版 |
sForum ][登录后回复]18楼