# fare

1. ### conditional formatting of date

Hi all, I have a column of dates and I need to highlight those dates that are older them 180 days. so fare I have the following =AND(\$S2<=TODAY()-180) the problem I have is that it also highlights the blank cells, what do I need to do / add to make it ignore the blank cells? thanks Steve
2. ### Reflash if or

Formula on c29 if b6 is KASUMBALESA or LUBUMBASHI then plug fare as 480,000
3. ### Find all possible paths between any two nodes in a bi-directional route map

requesting for the vba program for finding all possible paths between any two nodes in a bi-directional route map. inpit is given in sheet 1 as a=from; B=to; C=distance, d= time; e= fare. output is given in sheet 2 as A1=from ....; B1= to ....; A2= possible path1; B2 = DISTANCE C2= TIME TAKEN...
4. ### Using excel to calculate taxi fares

<tbody> Basic Fare (\$) Normal Medium Large Flag Down Fee (Inclusive of the first KM 3.00 3.90 5.00 Every 400m thereafter or less up to 10km 0.22 0.25 0.33 Every 350 metres thereafter or less after 10 km 0.18 0.20 0.28 Every 45 secs of waiting or less 0.20 0.20 0.20 </tbody> I am...