I can write functions in PHP & MySQL, but can't get my headd aroun
another language for Excel.

I have a spreadsheet with 2 columns for dates (B & C), a duratio
column (D) and a Yes or No column (E). We fill column B with the date
car arrives at our workshop, C with the date it leaves, D with th
duration of time we had it and E if it has been added to the insuranc
database [if it is with us more than 14 days].

I need to work out the duration column with the following style o
function...

Code
-------------------
   if $C2="" then ($D2="todays date"-$B2) else ($D2=$C2-$B2
-------------------

I also need a function to perfom the following conditional format...

Code
-------------------
   if $D2>14
 if $E2="Yes"      - Highlight row in BLUE
 else              - Highlight row in RE
-------------------

Any help with this would be really grateful
Ia