- Recommend:
- 0 Comments
Spreadsheet Tips
How do you count the ways? Excel offers numerous counting techniques.
How Many Days in the Month?
Excel lacks a function for calculating the number of days in a particular month, so you'll need to construct your own formula. If cell A1 contains a date, this formula will return the number of days in the month: =day(date(year(A1),month(A1)+1,1)1).
1-2-3's @dateinfo function is more helpful. The second argument for this function determines the type of information to return about a date (oddly enough, '7' yields the number of days in the month). This formula refers to a date in cell A1: @dateinfo(A1,7).
- « Prev
- Page 7 of 7
Would you recommend this story? YES NO
- Recommend:
- 0 Comments
-
Become an Android authority
Play music or games, run productivity apps and essential utilities.
-
PCWorld on your iPad!
PCWorldDaily gives you the best from our experts each day.
Lenovo Laptop Deals
-
IdeaPad U300s If there's a laptop that deserves the moniker "Ultrabook" it's the Lenovo IdeaPad U300s.
Buy now direct from Lenovo -
ThinkPad X220 Fast and light, with great input ergonomics and battery life, this powerhouse ultraportable is best-of-breed.
Buy now direct from Lenovo -
ThinkPad T420 Just about every IT person we know swears by the T series--for their clients and themselves.
Buy now direct from Lenovo
Similar Articles:
- 12 Criteria for Selecting the Best ERP System Replacement An ERP system is your information backbone and reaches into all areas of your business and value chain. Replacing it can open unlimited business opportunities. This white paper explains the 12 criteria that allow you to identify and select the solution that will meet these expectations.
- Leveraging Social Computing Technologies for ERP Applications This white paper details how Web 2.0 technologies support business strategies by improving efficiency, productivity, and collaboration.
Today's Special Offers
Editors' Picks
-
5 Common E-Mail Management Mistakes and How to Avoid Them
-
Researchers Identify Stuxnet-like Cyberespionage Malware Called 'Flame'
-
Should Facebook Make a Smartphone?
-
Facebook Eyes Facial Recognition Firm for Purchase, Report
-
Scanning Negatives, Shooting the Moon, Fixing the Colors in a Photo
-
Experts Question the Need for a Facebook Smartphone
-
GameStop Pitches Android Tablets to Gamers
-
Remove a Program That Lacks an Uninstaller
-
Rare Working Apple-1 Computer to Be Auctioned by Sotheby's
-
Facebook Phone Rumors Surface, Again
-
LG Working on Retina-beating 5-inch Smartphone Display
-
Information of U.S. Federal Employees Exposed
Ad Choices