DATEDIF() function in Apple Numbers

Подписаться 42 тыс.

Просмотров 8 тыс.

50% 1

How to use Numbers on a Mac
In this second episode covering Date and Time functions in Apple Numbers I've created a detailed tutorial on the DATEDIF() function.
This tutorial is useful for anyone learning about formulas in Numbers however it is aimed at beginners.
Check out my other tutorials for Apple Numbers:
• HOUR(), MINUTE(), and ...
• DAY(), DAYNAME(), and ...
• EOMONTH() function in ...
• EDATE() function in Ap...
• TODAY() and NOW() func...
• REGEX() and SUMIF() - ...
• DATEVALUE() function i...
• DATE() function in App...
• Create CHARTS in Apple...
• SUM(), SUMIF(), and SU...
Mac Numbers Function
#numbers, #apple, #spreadsheet, #spreadsheettutorial, #date, #datedif

Опубликовано:

1 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 21

@utnietje 7 месяцев назад

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

@apple-a-day 7 месяцев назад

Thanks!! Many more to come!

@dynamoofpower 10 месяцев назад

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

@apple-a-day 10 месяцев назад

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

@CorrinneJurenka 8 месяцев назад

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

@apple-a-day 8 месяцев назад

Glad it helped! Thanks for watching!

@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

@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?