jensloth13
New Member
- Joined
- Aug 19, 2014
- Messages
- 4
Hello, can someone please help me with a couple of formulas? Is it possible if a word in a certain cell can generate a number in a different cell? For example, if the word DOG is in cell A1 then B1 would generate the number 1, but if cell A1 had CAT, then cell B1 would generate the number 2? My second question is - If I have one cell that has a particular date (lodgement date), and then another cell has a completed date and there is a 5 day turn around time - is there a way to calculate how many days it took in a different cell (but not including holidays and weekends?) eg. Lodged 8/8/14 completed 13/8/14 - the cell would generate 4 days. THANKS SO MUCH!!!