VPS for Traders





Search This Blog

Pages

Google

Day of Week in Excel

Source : http://www.ozgrid.com/Excel/day-of-week.htm

Sometimes we need to know the Day Of Week (DOW) of 12-July-2008 which after we check at the calendar, 12-July-2008 is Saturday.

Here is how to do it :
=CHOOSE(WEEKDAY(A1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")

or in Bahasa :
=CHOOSE(WEEKDAY(A1),"Minggu","Senin","Selasa","Rabu","Kamis","Jumat","Sabtu")


And don't forget to change the A1 with the cell contain the source date you want to know the DOW.

I hope this tips might help you.

Have a nice day.

Agus Pang.
Medio in July 2008, Jakarta.

LifesDream - earn money each month





Verifield - Innovative Wealth Management

Verifield - your proven partners on stock markets Hasilkan uang dari Internet? Why Not? AVAZZY.com - Real business and real incomes

Alert Pay.. Get paid for subscribe...

DbClix Join 4Shared Now!

Liberty Reserve - Online Investment


Head Tail Game Liberty Reserve LR

Flip N Win

DepositFiles

Google

Get Paid to sign Up.

Internet Pay to Click

YOU can make $THOUSANDS of dollars per month...Starting from $0.00!

LinkGrand.com


Baca iklan .. dibayar loh...!

www.easyhits4u.com

EasyHits4U.com - Your Free Traffic Exchange - 1:1 Exchange Ratio, 5-Tier Referral Program. FREE Advertising! DonkeyMails.com: No Minimum Payout

Yahoo! Movies News & Gossip

Alexa

Alexa review on mInvestment