DATEDIF() function in Apple Numbers

[@andriyivanov4810]

Thank you very much for your efforts. Pls advise how to return difference between dates in hrs?

[@apple-a-day]

Hi there and thanks for the question. All you have to do is multiple the DATEDIF result by 24. Here's an example: =DATEDIF("2024-01-01","2024-02-02","D") * 24 or if the dates come from cells: =DATEDIF(A2, A3, "D") * 24 Hope this helps and thanks or watching!

[@CorrinneJurenka]

Thank you! so much easier than the formula I had inherited in a worksheet !!!

[@apple-a-day]

Glad it helped! Thanks for watching!

[@dynamoofpower]

Seriously, I can't thank you enough for how much this helped me!

[@apple-a-day]

Thanks so much! I’m glad it was helpful. Thanks for watching!

[@utnietje]

Thank you, you explaned it realy easy. Love too work with numbers. Hope you cover a lot off formuler’s .

[@apple-a-day]

Thanks!! Many more to come!

[@JRossHunter]

THANK YOU, I think this answers my question from a while back on how to have a spreadsheet dynamically update age. I'll see if I can get it to work.

[@JRossHunter]

Works😀

[@apple-a-day]

That’s great news! Glad I could help. Thanks for watching!

[@JRossHunter]

@@apple-a-day Now I have it working to show years, months, days. Wonderful.

[@apple-a-day]

@@JRossHunter Awesome!

[@JRossHunter]

Let me say this upfront, I'm not strong in math. I'm not understanding something in how Numbers display years, months, days when displaying an age calculation. For instance I'm writing this on March 2, 2023. My birthday is 3/23/1948. The cell says today I'm 74 years, 11 months and seven days old. It's 21 days until my birthday. How does Numbers calculate the "days"? Does it account for different month lengths?

[@EpicPublisher]

I am trying to figure out how to have a column of dates on the left and I want numbers to auto populate the date. How do I do this?

[@apple-a-day]

Hello there! If I understand your question correctly, that's actually pretty easy to do. Enter in a valid date in the first cell at the top of the column (eg. 2022-03-23). It should get recognized as a date but if you want to force it, you can then set the Cell Data Format to "Date & Time". Then in the cell underneath the date you just entered, type = to bring up the formula editor, then select the date cell and then type '+1' and press return Then select the formula cell and copy it and then paste it into every cell underneath. That should give you a full range of dates, 1 day apart. Hope that's what you were looking for. Thanks for watching!

[@EpicPublisher]

I appreciate you answering! It seems like such a basic function. I am still not able to make it work. I have tried to enter into the first cell a valid date using the date function. Then in the next cell type = formula editor get date cell, but I am unable to type +1 without a big red exclamation point coming up. Then I tried to put in a valid date without the date function in the first cell-same results. Do you have any idea what I am doing incorrectly? Thank you so much!@@apple-a-day

[@apple-a-day]

I just did a quick recording to show how it should work. Hopefully this is the answer you're looking for. It's a DropBox link: www.dropbox.com/s/zxhwaidzbvwlaiz/NumbersDateColumn.mov?dl=0

[@adco]

Big help👍

[@apple-a-day]

Thanks!