Trying to figure out if a date occurs during a leap year in Microsoft Excel? It's February 29th, and I have decided to post a formula that will help you to quickly determine this for any given date.If cell A1 contains the year alone (e.g. '2012'), then the following formula will return 'TRUE' if it is a leap year (and 'FALSE' if it isn't):=IF(OR(MOD(A1,400)=0,AND(MOD(A1,4)=0,MOD(A1,100)<>0)),TRUE,FALSE)If cell A1 contains an entire date (e.g. '2/29/2012'), then you will want to adjust your formula to use only the year portion of the date...
This week I had an e-mail from someone who was frustrated with how it had become so slow to scroll through one of his Microsoft Word documents. I immediately asked if there were a lot of images in it, and he replied to say that it was absolutely full of high-resolution pictures.If you've ever worked with an image-heavy document, you might have experienced this problem with slow scrolling. The good news is that you can speed it up again if you're willing to temporarily make all of those images invisible.Go to the 'File' tab, and then choose 'Options'....
Subscribe to:
Posts (Atom)
Posts
