Hi, Guity,
Have you ensured that
1. "Match entire cell contents" is not checked in the find/replace dialog box?
2. The "Look in" option is enabled with "Formula" and not with "Values" or "Comments"?
I toyed with the idea for some more time and came up with this formula. it works just fine.
Requirements first:
1. I need to calculate the sixth working day from the date of receipt of a project. The sixth working day will be the due date.
2.Saturday are working days for most Indian...
Thank you. I myself should have found the use of Networkdays function :(.
I just tried the formula by Pearson and found it to be more useful. I've to try the UDF as I'm not very comfortable with VBA - have to go slowly.
Thanks a ton.
Murugaraj
Hui,
I can't resist but wonder how smart your formula is. thanks a ton.
@cyrilz: your trick is good, too; but it is a little roundabout. Thanks for sharing.
Murugaraj
Oh, but I'm yet to learn macros. My present knowledge of macros is recording and editing them to a certain level. I think it's time I try that too. Thanks, Hui.
We can use CELL function to retrieve various data about a cell and use them in formulas too. Is there a similar way to use sheet names?
I have a workbook with productivity of each employee in a single table (a table with 20 employee names with their daily productivity). There is another...
Thanks Hui, I got the logic. I made a small change and used:
=SUMPRODUCT(A2:A10,((INT(B2:B10)=DATEVALUE("6/23/2010"))*(C4:C10=""))). And it worked just fine. Thanks again.
Murugaraj
Dear Chandoo and Hui,
Thanks for your help. My dates have times, so I can use Chandoo's suggestion.
However, when I tried, I got the sum wrong (it was 0 always!). I tried to find where I'm going wrong. I get a bizarre result at the following step:INT(C4:C10)="6/23/2010" is always FALSE--even...
The first column of my excel sheet contains the number of units (integers); the second column has the despatch date; and the third column contains the due date with time (e.g. 6/29/10 10:38). I'm interested in counting the number of units not yet despatched. That is:
count "the number of units"...