Fetch multiple data from excel

Closed
ritz - Sep 28, 2009 at 11:39 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 29, 2009 at 08:34 PM
Hi geeks,

I require your help in following query. I have a table table called project

It contains following items
E1 F1 G1 H1
Activity Name No of Days Start Date End Date
Requirement gathering 10 28-Jan-09 10-Feb-09
BRS IT 1 11-Feb-09 11-Feb-09

Based on the table, please help me with a macro which does following....
1) checks system date-- if system date is 9-Feb-09, then macro understands that it has to look at Requirement gathering activity.
2) once done it should count no of days starting from start date to system date excluding saturdays & sundays.

thanks frnds
ritz
Related:

2 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 29, 2009 at 05:57 AM
quote
if system date is 9-Feb-09, then macro understands that it has to look at Requirement gathering activity.
unquote
what is the logic. Is it because end date is nearest to system date (that is today) wheras the BRS IT end date is not nearest date.
0
venkat, it sud check start date >= system date >= end date. Once macro identifies that it is in between a particluar start and end date. A for loop sud start
for i= start date to system date
check if date is sunday or saturday , if no then counter ++
next start date..

here i just want to know take the count of days between start date aND systen date.

thanks
Ritz
0
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 29, 2009 at 08:34 PM
post a very small extract of your data.
0