Andy wants to add a script on his website that will automatically update the current date when the script loads in the browser.

The script that Andy would want to use is Javascript, here is the source code: document.getElementById("para1").innerHTML = formatAMPM();
function formatAMPM() {var d = new Date(),    minutes = d.getMinutes().toString().length == 1 ? '0'+d.getMinutes() : d.getMinutes(),    hours = d.getHours().toString().length == 1 ? '0'+d.getHours() : d.getHours(),    ampm = d.getHours() >= 12 ? 'pm' : 'am',    months = ['Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'],    days = ['Sun','Mon','Tue','Wed','Thu','Fri','Sat'];return days[d.getDay()]+' '+months[d.getMonth()]+' '+d.getDate()+' '+d.getFullYear()+' '+hours+':'+minutes+ampm;}

The HTML code needed to call this Javascript on his website is this: <div id="para1"></div>

You could call the Javascript up using PHP.

Hope this helps! Good luck! :) 

1. highlight the data range you want for your format
2 choose format > conditional formatting in the top menu
3. choose “custom formula is “ rule ..
5.enter the formula using $ sign to lock your column reference