Help with day of week?

[Ian1506]

Hi folks. I would like to set up my spreadsheet to only place bets on UK markets on certain days of the week. eg Mon/Wed. This would be easy if I was living in the UK as I could use a Now() function to return the day of the week. Because I live in Australia I am having trouble getting my head around it.

Does anyone know of a way I can use my local time, subtract 11 hours and so display current UK time, date and day of week.

Or...is there a way to take the date and time from A1 to generate a day of the week.

I'd rather not have to reset my computer clock to UK time.

Cheers Ian

[alrodopial]

You should find something useful here

http://www.cpearson.com/excel/topic.aspx

[Ian1506]

Thanks Alrodpial. Think I've got it now.