Remember Me?

#1
June 9th 06, 03:36 PM posted to microsoft.public.excel.worksheet.functions
 Scoooter Posts: n/a
Desperately need help with 3 calculations

Dear All

I should first say that I have no knowledge about the If Function in
Excel although I have been trying to figure it out for weeks now. I
seem to be able to be able to do simple ones but to save time I need to
apply the following conditions to nested If Function's for Days
Elapsed, Number of Days Remaining and Due Date. I have tried to think
in depth of what I am trying to achieve so apologies if it is too much
detail. Any help would be greatly appreciated and remember, I don't
have a clue on what I am talking about so please excuse my ignorance.

Scoooter

Days Elapsed (AK)
Display the number of workdays that have elapsed using the following
conditions:

If AA2 = blank then leave blank without displaying an error message.
If AA2 = "St1" then calculate Workdays elapsed from U2 and display.
If AA2 = "St2" then calculate Workdays elapsed from Z2 and display.
If AA2 = "St3" then calculate Workdays elapsed from Z2 and display.
If AA2 = "PE" then calculate Workdays elapsed from U2 and display.
If AA2 = "FOI" then calculate Workdays elapsed from U2 and display.
If AA2 = anything else then return "Not Required"
If AO2 = is populated with a date then quit counting days elapsed and
display final figure.

I also need to exclude the following holidays:
14/04/2006 Friday
17/04/2006 Monday
01/05/2006 Monday
29/05/2006 Monday
28/08/2006 Monday
25/12/2006 Monday
26/12/2006 Tuesday
01/01/2007 Monday

Number Of Days Remaining (AM):
If AA2 = blank then leave blank without displaying an error message.
If AA2 = "St" then countdown from 10 Workdays and display.
If AA2 = "St2" then countdown from 20 Workdays and display.
If AA2 = "St3" then countdown from 28 Workdays and display.
If AA2 = "PE" then countdown 10 Workdays and display.
If AA2 = "FOI" then countdown from 20 Workdays and display.
If AA2 = anything else then return "Not Required".
If AO2 = is populated with a date then quit counting down and display
final figure.

I also need to exclude the following holidays:
14/04/2006 Friday
17/04/2006 Monday
01/05/2006 Monday
29/05/2006 Monday
28/08/2006 Monday
25/12/2006 Monday
26/12/2006 Tuesday
01/01/2007 Monday

Due Date (AN):
If AA2 = blank then leave blank without displaying an error message.
If AA2 = "St1" then add 10 Workdays to date in U2 and display
revised date.
If AA2 = "St2" then add 20 Workdays to date in Z2 and display
revised date.
If AA2 = "St3" then add 28 Workdays to date in Z2 and display
revised date.
If AA2 = "PE" then add 10 Workdays to date in U2 and display
revised date.
If AA2 = "FOI" then add 20 Workdays to date in U2 and display
revised date.
If AA2 = anything else then return "Not Required"

I also need to exclude the following holidays:
14/04/2006 Friday
17/04/2006 Monday
01/05/2006 Monday
29/05/2006 Monday
28/08/2006 Monday
25/12/2006 Monday
26/12/2006 Tuesday
01/01/2007 Monday

#2
June 9th 06, 03:57 PM posted to microsoft.public.excel.worksheet.functions
 Marcelo Posts: n/a
Desperately need help with 3 calculations

Hi Scoooter,

http://www.cpearson.com/excel/DateIntervals.htm

hope this helps
regards from Brazil
Marcelo

"Scoooter" escreveu:

Dear All

I should first say that I have no knowledge about the If Function in
Excel although I have been trying to figure it out for weeks now. I
seem to be able to be able to do simple ones but to save time I need to
apply the following conditions to nested If Function's for Days
Elapsed, Number of Days Remaining and Due Date. I have tried to think
in depth of what I am trying to achieve so apologies if it is too much
detail. Any help would be greatly appreciated and remember, I don't
have a clue on what I am talking about so please excuse my ignorance.

Scoooter

Days Elapsed (AK)
Display the number of workdays that have elapsed using the following
conditions:

If AA2 = blank then leave blank without displaying an error message.
If AA2 = "St1" then calculate Workdays elapsed from U2 and display.
If AA2 = "St2" then calculate Workdays elapsed from Z2 and display.
If AA2 = "St3" then calculate Workdays elapsed from Z2 and display.
If AA2 = "PE" then calculate Workdays elapsed from U2 and display.
If AA2 = "FOI" then calculate Workdays elapsed from U2 and display.
If AA2 = anything else then return "Not Required"
If AO2 = is populated with a date then quit counting days elapsed and
display final figure.

I also need to exclude the following holidays:
14/04/2006 Friday
17/04/2006 Monday
01/05/2006 Monday
29/05/2006 Monday
28/08/2006 Monday
25/12/2006 Monday
26/12/2006 Tuesday
01/01/2007 Monday

Number Of Days Remaining (AM):
If AA2 = blank then leave blank without displaying an error message.
If AA2 = "St" then countdown from 10 Workdays and display.
If AA2 = "St2" then countdown from 20 Workdays and display.
If AA2 = "St3" then countdown from 28 Workdays and display.
If AA2 = "PE" then countdown 10 Workdays and display.
If AA2 = "FOI" then countdown from 20 Workdays and display.
If AA2 = anything else then return "Not Required".
If AO2 = is populated with a date then quit counting down and display
final figure.

I also need to exclude the following holidays:
14/04/2006 Friday
17/04/2006 Monday
01/05/2006 Monday
29/05/2006 Monday
28/08/2006 Monday
25/12/2006 Monday
26/12/2006 Tuesday
01/01/2007 Monday

Due Date (AN):
If AA2 = blank then leave blank without displaying an error message.
If AA2 = "St1" then add 10 Workdays to date in U2 and display
revised date.
If AA2 = "St2" then add 20 Workdays to date in Z2 and display
revised date.
If AA2 = "St3" then add 28 Workdays to date in Z2 and display
revised date.
If AA2 = "PE" then add 10 Workdays to date in U2 and display
revised date.
If AA2 = "FOI" then add 20 Workdays to date in U2 and display
revised date.
If AA2 = anything else then return "Not Required"

I also need to exclude the following holidays:
14/04/2006 Friday
17/04/2006 Monday
01/05/2006 Monday
29/05/2006 Monday
28/08/2006 Monday
25/12/2006 Monday
26/12/2006 Tuesday
01/01/2007 Monday

#3
June 9th 06, 03:59 PM posted to microsoft.public.excel.worksheet.functions
 Fonz Posts: n/a
Desperately need help with 3 calculations

"Scoooter" wrote:

Dear All

I should first say that I have no knowledge about the If Function in
Excel although I have been trying to figure it out for weeks now. I
seem to be able to be able to do simple ones but to save time I need to
apply the following conditions to nested If Function's for Days
Elapsed, Number of Days Remaining and Due Date. I have tried to think
in depth of what I am trying to achieve so apologies if it is too much
detail. Any help would be greatly appreciated and remember, I don't
have a clue on what I am talking about so please excuse my ignorance.

Scoooter

Days Elapsed (AK)
Display the number of workdays that have elapsed using the following
conditions:

If AA2 = blank then leave blank without displaying an error message.
If AA2 = "St1" then calculate Workdays elapsed from U2 and display.
If AA2 = "St2" then calculate Workdays elapsed from Z2 and display.
If AA2 = "St3" then calculate Workdays elapsed from Z2 and display.
If AA2 = "PE" then calculate Workdays elapsed from U2 and display.
If AA2 = "FOI" then calculate Workdays elapsed from U2 and display.
If AA2 = anything else then return "Not Required"
If AO2 = is populated with a date then quit counting days elapsed and
display final figure.

I also need to exclude the following holidays:
14/04/2006 Friday
17/04/2006 Monday
01/05/2006 Monday
29/05/2006 Monday
28/08/2006 Monday
25/12/2006 Monday
26/12/2006 Tuesday
01/01/2007 Monday

Number Of Days Remaining (AM):
If AA2 = blank then leave blank without displaying an error message.
If AA2 = "St" then countdown from 10 Workdays and display.
If AA2 = "St2" then countdown from 20 Workdays and display.
If AA2 = "St3" then countdown from 28 Workdays and display.
If AA2 = "PE" then countdown 10 Workdays and display.
If AA2 = "FOI" then countdown from 20 Workdays and display.
If AA2 = anything else then return "Not Required".
If AO2 = is populated with a date then quit counting down and display
final figure.

I also need to exclude the following holidays:
14/04/2006 Friday
17/04/2006 Monday
01/05/2006 Monday
29/05/2006 Monday
28/08/2006 Monday
25/12/2006 Monday
26/12/2006 Tuesday
01/01/2007 Monday

Due Date (AN):
If AA2 = blank then leave blank without displaying an error message.
If AA2 = "St1" then add 10 Workdays to date in U2 and display
revised date.
If AA2 = "St2" then add 20 Workdays to date in Z2 and display
revised date.
If AA2 = "St3" then add 28 Workdays to date in Z2 and display
revised date.
If AA2 = "PE" then add 10 Workdays to date in U2 and display
revised date.
If AA2 = "FOI" then add 20 Workdays to date in U2 and display
revised date.
If AA2 = anything else then return "Not Required"

I also need to exclude the following holidays:
14/04/2006 Friday
17/04/2006 Monday
01/05/2006 Monday
29/05/2006 Monday
28/08/2006 Monday
25/12/2006 Monday
26/12/2006 Tuesday
01/01/2007 Monday

#4
June 12th 06, 04:28 PM posted to microsoft.public.excel.worksheet.functions
 Scoooter Posts: n/a
Desperately need help with 3 calculations

Thanks for that Marcelo, although it does not appear to be specific
enough.

Scoooter

Marcelo wrote:

Hi Scoooter,

http://www.cpearson.com/excel/DateIntervals.htm

hope this helps
regards from Brazil
Marcelo

"Scoooter" escreveu:

Dear All

I should first say that I have no knowledge about the If Function in
Excel although I have been trying to figure it out for weeks now. I
seem to be able to be able to do simple ones but to save time I need to
apply the following conditions to nested If Function's for Days
Elapsed, Number of Days Remaining and Due Date. I have tried to think
in depth of what I am trying to achieve so apologies if it is too much
detail. Any help would be greatly appreciated and remember, I don't
have a clue on what I am talking about so please excuse my ignorance.

Scoooter

Days Elapsed (AK)
Display the number of workdays that have elapsed using the following
conditions:

If AA2 = blank then leave blank without displaying an error message.
If AA2 = "St1" then calculate Workdays elapsed from U2 and display.
If AA2 = "St2" then calculate Workdays elapsed from Z2 and display.
If AA2 = "St3" then calculate Workdays elapsed from Z2 and display.
If AA2 = "PE" then calculate Workdays elapsed from U2 and display.
If AA2 = "FOI" then calculate Workdays elapsed from U2 and display.
If AA2 = anything else then return "Not Required"
If AO2 = is populated with a date then quit counting days elapsed and
display final figure.

I also need to exclude the following holidays:
14/04/2006 Friday
17/04/2006 Monday
01/05/2006 Monday
29/05/2006 Monday
28/08/2006 Monday
25/12/2006 Monday
26/12/2006 Tuesday
01/01/2007 Monday

Number Of Days Remaining (AM):
If AA2 = blank then leave blank without displaying an error message.
If AA2 = "St" then countdown from 10 Workdays and display.
If AA2 = "St2" then countdown from 20 Workdays and display.
If AA2 = "St3" then countdown from 28 Workdays and display.
If AA2 = "PE" then countdown 10 Workdays and display.
If AA2 = "FOI" then countdown from 20 Workdays and display.
If AA2 = anything else then return "Not Required".
If AO2 = is populated with a date then quit counting down and display
final figure.

I also need to exclude the following holidays:
14/04/2006 Friday
17/04/2006 Monday
01/05/2006 Monday
29/05/2006 Monday
28/08/2006 Monday
25/12/2006 Monday
26/12/2006 Tuesday
01/01/2007 Monday

Due Date (AN):
If AA2 = blank then leave blank without displaying an error message.
If AA2 = "St1" then add 10 Workdays to date in U2 and display
revised date.
If AA2 = "St2" then add 20 Workdays to date in Z2 and display
revised date.
If AA2 = "St3" then add 28 Workdays to date in Z2 and display
revised date.
If AA2 = "PE" then add 10 Workdays to date in U2 and display
revised date.
If AA2 = "FOI" then add 20 Workdays to date in U2 and display
revised date.
If AA2 = anything else then return "Not Required"

I also need to exclude the following holidays:
14/04/2006 Friday
17/04/2006 Monday
01/05/2006 Monday
29/05/2006 Monday
28/08/2006 Monday
25/12/2006 Monday
26/12/2006 Tuesday
01/01/2007 Monday

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post juliadesi Excel Discussion (Misc queries) 6 March 17th 06 01:14 PM jerry Excel Discussion (Misc queries) 0 October 3rd 05 07:25 PM Anand Excel Worksheet Functions 2 September 14th 05 07:12 PM Stephen McArthu Excel Discussion (Misc queries) 4 June 6th 05 04:35 PM Krishna Excel Discussion (Misc queries) 6 April 8th 05 02:57 PM

All times are GMT +1. The time now is 01:13 AM.