Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 9th 06, 03:36 PM posted to microsoft.public.excel.worksheet.functions
Scoooter
 
Posts: n/a
Default 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.

Thanks in advance.

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   Report Post  
Old June 9th 06, 03:57 PM posted to microsoft.public.excel.worksheet.functions
Marcelo
 
Posts: n/a
Default Desperately need help with 3 calculations

Hi Scoooter,

maybe the tips on the CPerson web page could help you

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.

Thanks in advance.

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   Report Post  
Old June 9th 06, 03:59 PM posted to microsoft.public.excel.worksheet.functions
Fonz
 
Posts: n/a
Default 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.

Thanks in advance.

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   Report Post  
Old June 12th 06, 04:28 PM posted to microsoft.public.excel.worksheet.functions
Scoooter
 
Posts: n/a
Default Desperately need help with 3 calculations

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

Scoooter

Marcelo wrote:

Hi Scoooter,

maybe the tips on the CPerson web page could help you

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.

Thanks in advance.

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
complex calculations juliadesi Excel Discussion (Misc queries) 6 March 17th 06 01:14 PM
Calculations based on PivotTable information jerry Excel Discussion (Misc queries) 0 October 3rd 05 07:25 PM
looping through a set of calculations Anand Excel Worksheet Functions 2 September 14th 05 07:12 PM
Calculations crossing multiple sheets Stephen McArthu Excel Discussion (Misc queries) 4 June 6th 05 04:35 PM
time interval calculations in excel Krishna Excel Discussion (Misc queries) 6 April 8th 05 02:57 PM


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

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017