Follow Us on Facebook

វចនានុក្រមខ្មែរ​
Khmer Dictionaries

Follow us on Twitter

Google+

Search More Information

Friday, March 21, 2014

Calendar Year in Excel 2010

Calendar Year in Excel 2010

=>Select 31 columns and wanted rows => Paste Formula below with Ctrl +Enter

=DATE(YEAR(B4),MONTH(B4),1)+{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31}-1

B4 is the source of month, example: January-2014. You can change to any month as you want.

Result:


There are formatting in the table. For example, Saturday and Sunday. Please do  as below

=>Select whole month => Conditional Formatting => New Rules => See below formula


=WEEKDAY(DATE(YEAR($B$6),MONTH($B$6),DAY(B$6)),2)>5

This is very important trick. B6 is the first day of the month. Please use ($) only one in DAY.


0 comments :

Post a Comment

Like Me on Facebook

Donation by PayPal

Blog Archive

Loading...