fixed : calculate the number of days between 2 dates

Question :

I want to integrate a formula in my spreadsheet (in Excel or Numbers) that calculates the number of days between 2 dates that I have in other cells on the spreadsheet.

How do I do that ?

Answer :

there are 2 formulas available to do this, choose the one that works best for you in Excel or Numbers :

formula =DUR2DAYS(enddatestartdate)+1

or

formula =DATEDIF(startdate, enddate, “D”)+1

NOTE : the “+1” in both these formulas is only needed if you want the number of days including both startdate and enddate !

That’s it !

enjoy 😉

Advertisement

fixed : can’t edit cells in Numbers

Question :

I made an extensive table in Numbers yesterday and saved when I was ready for the day. Today I want to work on it again, and it opens without a problem, but I can’t edit any cells… I can’t click in any cell, I can’t type anything inside it and the 1-2-3 numbering of the rows and the A-B-C ‘numbering’ of the columns doesn’t appear either…

The only thing I can edit are three cells at the top of the page…

What is wrong ?

 

Answer :

The solution might be rather simple :  probably, you have accidentally entered the Printing Preview mode.

You can see you are in Printing Preview mode when there are 2 buttons visible at the bottom the Editing pane on the right : “Done” and “Print…”

If so, just click on the “Done”-button to leave the Printing Preview mode and go back to the main Editing screen.

That’s it !

enjoy 😉

tip : quickly typ numbers and non-alphanumeric signs on iPad

TIP :

there is a quick way to typ numbers (and other SHIFT-accessable digits) on iPad in iOS12 and iPadOS :

when the on-screen keyboard is visible, just swipe-down (pull-down) on the on-screen key to get it’s SHIFT-version

e.g. : if you swipe down the 3-key, you will typ the #-sign, and if you swipe-down the 7-key, you will typ the &-sign

enjoy 😉

 

fixed : PowerPoint presentation too large for eMail

Question :

I just made a beautiful PowerPoint presentation which I want to eMail to my friend. When I tried to eMail it, that seemed to work okay at first, but a few moments later I got an error message saying that the eMail could not be sent.

How can I fix this ?

 

Answer :

eMail providers have set a limit to the attachments’ file size per eMail to prevent cluttering the eMail traffic and flooding the recipient’s eMail inbox. For most providers this limit is set to about 5MB of attached files per eMail message. Some providers have expanded this limit to 10MB, and providers like Gmail, Hotmail and Yahoo! even allow you to attach up to 25MB of files to each eMail.

But if your PowerPoint presentation is even larger than 25MB (which might easily occur if you have done your best to make it a beautiful presentation), you will probably do the recipient  a pleasure if you send a smaller file, especially if they are planning on viewing it on a mobile device. The easiest way to ‘shrink’ the size of a presentation is to convert it into a PDF-file. (a PDF-file is even more versatile than a PowerPoint-presentation, as it also can be viewed by people that don’t have PowerPoint software installed)

To convert your PowerPoint-presentation into a PDF-file, do this :

In MacOSX :

– open your presentation in PowerPoint

– then go to “File” in the upper menu bar and select “Print” from the pulldown menu that appears

– in the “Print” menu that appears, adjust everything as desired, then click on the “PDF” button (bottom left)

– in the pulldown menu that appears, choose “Mail PDF” and a new eMail message will be made for you including your Presentation as an attachment

…or you can choose “Save as PDF…” to first save the PDF-version of your presentation to your Mac so you can attach it to any eMail later on

Note : the above procedure also works in other OSX programs like Word, Excel, Pages, Numbers, Keynote, etc.

For Windows users, the general idea is similar but slightly different :

http://office.microsoft.com/en-001/powerpoint-help/save-as-pdf-HA010064992.aspx

If the standard conversion of your PowerPoint into a PDF still turns up with a PDF-file that is too large to eMail, you can adjust the conversion settings, as described here :

How to create even smaller PDFs in OSX

You might also want to try the “Reduce File Size” that is in the “File”-tab of each Office 2011 application (so in Word, PowerPoint and Excel). This option will only reduce the size of the pictures inside the document. The smallest this option can reduce to is 96ppi a.k.a. “Best for sending in e-mail”. This is an interesting option, but converting to PDF usually leads to even more file size reduction.

And if the recipient insists on getting the original PowerPoint-file, you could do as a lot of professionals do, and send your presentation trough the FREE WeTransfer service :

http://www.wetransfer.com

that’s it !

enjoy !

😉

Donate Button (MacManusNL)

tip : get Keynote, Pages & Numbers for FREE with OSX 10.9 Mavericks

Question :

I heard that you can get the new versions of Keynote, Pages and Numbers for FREE when you upgrade to OSX 10.9 Mavericks.

Is that true ? And how do I get them ?

Answer :

Yes, it’s true !

But… there is a tricky part in this… BEWARE !

This can ONLY be done BEFORE you upgrade to OSX 10.9 Mavericks, as it is a (deliberate) loophole in the OSX 10.9 Mavericks upgrade process :

Apple is shifting all installations of it’s software to the Mac App Store, and the OSX 10.9 Mavericks installer therefore checks for all previous versions of Apple app’s that you have installed on OSX 10.8 Mountain Lion…

all versions of Keynote, Pages, Numbers and Aperture (!) will be ‘upgraded’ to the latest Mac App Store versions of the same apps.

note : even trail-versions and illegally copied versions will be ‘upgraded’ to full legal versions for FREE !

So, get an old version of the iWork apps (and/or Aperture) installed before you upgrade to OSX 10.9 Mavericks, and you get the new versions for FREE.

Enjoy !

Donate Button (MacManusNL)

fixed : change the Currency-format of only a few cells in Numbers (from iWork)

Question :

I’m using the Apple Numbers spreadsheet-app (from iWork) and I want to use multiple currencies in one spreadsheet (US dollars, GB pounds and Euros). I tried “Create / Change Custom Cell Format” from the “Format”-menu, but there the currency is set to default to my local currency (Euros) and I can’t change it…

This must be possible, right ?

But, how do I do it ?

Answer :

The trick is you should change the currency format of a (group of) cell(s) in the “Inspector”…

Here’s how to :

– in Numbers, select the cell or cells of which you want to change the currency

– then click on the “Inspector” (info-sign shaped button on the right of the upper bar of the spreadsheet-window)

– in the “Cells”-window that opens, choose the tab marked “42” (*)

– there, under “Cell Format” you should change the default “Automatic” to “Currency” and choose the one you want to use

That’s it !

😉

(*) this is probably a subtile reference to “The Hitchhikers Guid To The Galaxy (H2G2)”, where 42 turns out to be the answer to “the ultimate question of life, the universe and everything”

Donate Button (all)