Follow Us on Facebook

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

Follow us on Twitter

Google+

Search More Information

Friday, March 21, 2014

Calendar Month in Excel 2010

Select 5 rows and 7 columns => Paste formula below with Ctrl + Enter

=DATE(YEAR(B2),MONTH(B2),1)-(WEEKDAY(DATE(YEAR(B2),MONTH(B2),1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1

Result:

and then formatting the last month.

=> Select whole calendar => Conditional Formatting =>


0 comments :

Post a Comment

Like Me on Facebook

Donation by PayPal

Blog Archive

Loading...