The Geek Worker

Solving IT Problems

Main menu

Skip to content
  • Home
  • About
  • Helpful Links

Tag Archives: Microsoft Office

How to Hide and Unhide Cells in Microsoft Excel

Posted on August 3, 2017 by Nils
Reply

This is a great little how-to on hiding and unhiding cells in Microsoft Excel: http://spreadsheets.about.com/od/excelformatting/qt/070814unhidecol.htm

Posted in Article | Tagged Excel, Microsoft, Microsoft Excel, Microsoft Office | Leave a reply

Excel Formula to get Number of Days in a Month

Posted on January 18, 2012 by Nils
20

It seems Excel still can’t tell me the days in a particular month.

The following formula works, though:

=DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1)

Obviously, A1 has to have a date in it.

Works like a charm:

 Update, much, much later: Looks like LibreOffice has a DAYSINMONTH function.

Posted in Article | Tagged Excel, LibreOffice, Microsoft Office, OpenOffice | 20 Replies

Tags

Apache Apple Chrome EasyRSA ejabberd Excel Geekworker iOS iPad iPhone iTunes Jetpack LibreOffice Links Linux Microsoft Microsoft Excel Microsoft Office MS Office OpenOffice openvpn postfix Python RDP RDSH Remote Desktop Scrivener Skyrim Skyrim Special Edition SSL subversion svn Synology USB Video Playback Wacom Windows Windows 10 Windows Server Wordpress Wordpress Multisite Workgroup WP Multisite Wrye Bash YouTube

Archives

  • ▼2021 (2)
    • ▼March (1)
      • iPhone: Can't Enter Recovery Mode
    • ►January (1)
  • ►2020 (4)
    • ►August (1)
    • ►July (1)
    • ►May (1)
    • ►January (1)
  • ►2019 (1)
    • ►May (1)
  • ►2018 (5)
    • ►November (3)
    • ►July (1)
    • ►January (1)
  • ►2017 (5)
    • ►August (4)
    • ►January (1)
  • ►2016 (3)
    • ►September (2)
    • ►July (1)
  • ►2015 (5)
    • ►October (1)
    • ►August (1)
    • ►July (1)
    • ►June (1)
    • ►May (1)
  • ►2014 (13)
    • ►December (2)
    • ►November (1)
    • ►October (2)
    • ►September (1)
    • ►August (1)
    • ►June (1)
    • ►April (4)
    • ►February (1)
  • ►2013 (13)
    • ►December (1)
    • ►November (5)
    • ►October (2)
    • ►September (1)
    • ►July (1)
    • ►June (1)
    • ►April (1)
    • ►February (1)
  • ►2012 (5)
    • ►October (1)
    • ►August (1)
    • ►March (2)
    • ►January (1)
  • ►2011 (7)
    • ►October (1)
    • ►September (1)
    • ►August (1)
    • ►June (4)
  • ►2007 (1)
    • ►July (1)

Advertisement

Recent Posts

  • iPhone: Can’t Enter Recovery Mode
  • Gnucash: “Install Online Price Retrieval for GnuCash” results in “Access is Denied” error
  • Windows 10 “Type here to search” Search in Taskbar not working
  • Windows 10: Microfreezes in Games
  • WordPress: Site not Secure despite SSL Certificate

Recent Comments

  • DaReclama on OpenVPN: IP packet with unknown IP version seen
  • vilva on Excel Formula to get Number of Days in a Month
  • Negative Time Values In Excel | The Geek Worker on Summing up times in Excel
  • Michael (Micky) Avidan on Excel Formula to get Number of Days in a Month
  • Nils on Excel Formula to get Number of Days in a Month

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 1 other subscriber

Archives

Categories

Proudly powered by WordPress | Theme: Duster by Automattic.