How many days in the month?

• Share
• Be the first to comment 0

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).

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

PC World

Best Deals on GoodGearGuide

Best Deals on PCWorld

Mobile PhonesView all »

\$346.15

\$250.77

\$789.00

\$392.80

\$322.80

\$862.80

\$853.93

\$379.00

\$532.80

\$382.80

\$332.80

\$245.00

\$482.80

\$338.80

\$624.00
• Samsung 749 - Samsung i9300 Ga...

\$449.00
NotebooksView all »

\$1398.99

\$45.00

\$60.00

\$1099.00

\$1999.00

\$1798.98

\$699.00

\$49.00

\$3999.00

\$45.00

\$999.00

\$1099.00

\$45.00

\$899.00

\$248.00
• Apple 4GB 1066Mhz SODIMM

\$58.00
TabletsView all »

\$760.00

\$588.00

\$629.00

\$699.98

\$899.00

\$569.00

\$699.00

\$551.88

\$409.00

\$529.00

\$319.00

\$724.53

\$479.00

\$699.00

\$500.98
• Samsung Pn: Sm-t2100zwaxsa Gal...

\$300.51
Printers & ScannersView all »

\$139.00

\$165.00

\$243.00

\$165.00

\$1583.00

\$598.99

\$243.00

\$598.99

\$999.00

\$376.00

\$296.00

\$75.00

\$1742.00

\$530.99

\$376.00
• Dell C2660dn Color Single Func...

\$598.99
Networking, Wireless & VoIPView all »

\$108.90

\$120.90

\$107.90

\$107.99

\$117.00

Compare & Save

Use WhistleOut's technology to compare:
Mobile phone plans & deals
Mobile phone models
Mobile phone carriers