pebzarolla
New Member
- Joined
- Oct 27, 2009
- Messages
- 6
Hi forum members, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I am trying to create a spreadsheet that determines due dates for assessments that are sent out for review and also determines whether the assessments were completed on time based on priority.<o></o>
So far I have been able to successfully complete the following (taking into account both working days (M-F) and holidays (defined in another column))<o></o>
Column A = Date Issued<o></o>
Column B = Date Assessment response required (This is calculated using the following formula: =WORKDAY(A5,3, Holidays))<o></o>
Column C = Date Assessment Received (Manual entry of date)<o></o>
Column D= Determines whether response received in time (This is calculated using the following formula: =IF(Cn>Bn,"No","Yes")<o></o>
<o></o>
I now need to add an additional column that allocates an assessment priority, this being Priority 1 = 1 Working Day, Priority 2 = 2 Working Days, and Priority 3 - 3 Working Days.<o></o>
On this basis the Response required and response received columns need to reflect the priority of the assessment.<o></o>
<o></o>
Any help greatly appreciated<o></o>
I am trying to create a spreadsheet that determines due dates for assessments that are sent out for review and also determines whether the assessments were completed on time based on priority.<o></o>
So far I have been able to successfully complete the following (taking into account both working days (M-F) and holidays (defined in another column))<o></o>
Column A = Date Issued<o></o>
Column B = Date Assessment response required (This is calculated using the following formula: =WORKDAY(A5,3, Holidays))<o></o>
Column C = Date Assessment Received (Manual entry of date)<o></o>
Column D= Determines whether response received in time (This is calculated using the following formula: =IF(Cn>Bn,"No","Yes")<o></o>
<o></o>
I now need to add an additional column that allocates an assessment priority, this being Priority 1 = 1 Working Day, Priority 2 = 2 Working Days, and Priority 3 - 3 Working Days.<o></o>
On this basis the Response required and response received columns need to reflect the priority of the assessment.<o></o>
<o></o>
Any help greatly appreciated<o></o>