Tag Archives: Numbers.app

fixed : calculate the number of days between 2 dates

Posted on by
Reply

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(enddate–startdate)+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

Posted on by
Reply

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 😉