DATE() function in Apple Numbers
HTML-код
- Опубликовано: 11 сен 2024
- How to use Numbers on a Mac
This is the first episode covering Date and Time functions in Apple Numbers. This tutorial is about the DATE() 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...
• DATEDIF() function in ...
• Create CHARTS in Apple...
• SUM(), SUMIF(), and SU...
Mac Numbers Function
#numbers, #apple, #spreadsheet, #spreadsheettutorial, #date #countblank
thanks for this video. You forgot to explain the most important part of it. How can I save time by using a function that types dates in columns as much as I need?
Thanks! I'm not sure I follow your question though.
@@apple-a-day hi, Thanks for replying. I meant how can I write a function that automatically put in dates to those columns I want for example if we say I want to write down all days from July to August in column A2 to A64. But instead of writing down same function by myself, I apply a function that fills all columns.
@@pw-gamer2903 Ahh ok. I think I understand. I think the simplest way to do that would be to put the July 1 in the cell where you want the dates to start. Let's say that it's in cell C3 for example. So in the cell underneath you would just add a new formula and put in C3+1. Then copy that formula to every cell underneath. That should auto-generate the dates for you. Hope this helps!
what if a sheet I have downloaded has the date in day/month/year format? How do I get Numbers to recognize it correctly and sort the sheet by date? When I try to sort it sees 06/12/2023 as June 12th but it's actually December 6th.
Hi there, that's a good question. You could try changing your date settings within System Settings. If you can't figure it out please email me the downloaded spreadsheet that is causing you this problem and I'll see if I can get it to work. My email is appleadaychannel@gmail.com
@@apple-a-day LOL sorry but I'm not emailing you my bank and Paypal reports for my business. Also I tried that already - if I change my system settings then it puts me on UK time also on the computer. I already found a work-around but I wish Apple would fix this. I copied and pasted into a Google sheet. Sorted just fine with no extra steps needed
@@DigitalPhotoMentor Haha yeah, don't blame you. Well I'm glad you found a work-around. I've not encountered this issue yet in my day-to-day use of Numbers. Thanks for the watching!
Thanks for the video! Is there a way to fill the table with the dates for every, say, Monday and Friday, without manually entering it each time? I tried to fill the first 3 cells with proper dates and then apply autofill, but unfortunately it just repeats the same entry again and again…
Hi there! If I understand your question correctly, you can put put the first Monday date in and then for the Friday just reference the Monday cell and add 4.
eg. Monday is Cell A1
then in Friday's cell enter =A1+4
Then when you change Monday's date the Friday date will always be 4 days later.
Hopefully that's what you were looking for. Thanks for watching!
Hello! Thanks for this!! I’m curious if there’s a way to create a calendar that starts on a different day than it normally would.. on a Wednesday. I tried editing the calendar that is offered on the Apple Numbers app but can’t seem to get it to work!
Hi there! I'm not certain that I follow. Are you suggesting to start a calendar month on a Day of the Week other than the true date in which the month would actually start? Or are you trying to set up a generic calendar that's not based on any real date?
@@apple-a-day well, I’m working on creating my own calendar for budgeting but I get paid on Wednesdays haha. So I wanted my calendar to be viewed Wednesday to Tuesday left to right if that makes sense! I was messing with it a bit and I think there has to be a way to do this but I haven’t figured it out yet lol
Ideally, I would have a base calendar that is set up that way and be able to duplicate it and change the month and year, and all of the days would adjust accordingly.
@@kimberlyr6258 Ahhh ok, I get it. So instead of displaying Sunday as the first day of the week, you want to display Wednesday. I'll take a look in the next day or so and get back to you.
@@apple-a-day yes, exactly! Thanks so much ☺️
@@kimberlyr6258 Here's a DropBox link to a Calendar that I modified from the Numbers Calendar Template. It has a Wednesday as a starting Day Of Week:
www.dropbox.com/t/f8xgw5aGmrPrKLkE
Hopefully this will work for you. If you would rather use what you already created instead, please send me an email with the attached Numbers document and I can help you out. Thanks!
How do you show the current date in the top right corner of a sheet, that automatically gets updated each day ? That’s the only thing I want to know.
Hi there, you can just use the =TODAY() function to display the current date. It automatically updates whenever the document is opened or if something in the document changes. Thanks for watching!
🙏 Thank You 🙏
i just want a shortcut for the date and another shortcut for the time, can you helpe me??
Unfortunately there are no built in Keyboard shortcuts for either adding the DATE() or TIME() functions. This might be possible using AppleScript but that is far too complicated to be answered here.
If you meant a way to quickly display the current date, that can be done with the TODAY() function
The current time can be displayed with the NOW() function but you would have to change your formatting to only show the TIME and not the DATE
Hope this helps
it helps a lot, thank you so much!!@@apple-a-day
Я посчитал количество дней между датами. Как перевести результат в месяцы, в годы?
Hello! If you wanted covert days to months you could use this equation:
=A1÷(365÷12)
A1 is the number of days. This will give you the number of months based on the average number of days in a month.
To conver to years this would work:
=A1÷365
Hope this helps.
Thanks for watching!
@@apple-a-day super. Excel есть функция по форматированию числа в годы-месяцы-недели-дни-Часы-минуты. Неужели этого нет в Numbers?
What formula produces consecutive dates for a month or week?
Do you mean that one cell would have one date and then another cell would be the next date? If that's the case you could just use the following formula:
=A2+1
Put that in each cell and it wall always add a day.
Disculpe, quizás lo haya comprendido mal, estoy utilizando un traductor automático. Necesitaba que la fecha cambiara de forma automática al comenzar un nuevo día en la misma celda de forma automática. ¿Con esta fórmula lo puede hacer? Gracias.
@@fgmjbm If you use the TODAY() function, it will always be the current day whenever your Numbers document is opened. That would automatically update the date in a cell for you. Hope this is what you were looking for.
@@apple-a-day Muchas gracias.
Thank you very much.
Great!
And what if I want to add the current date to a cell..... and every time I open the file, the cell show the current day?
Cheers!
Hi there and thanks for the question. There's a Numbers formula for that: TODAY()
This returns the current date which updated whenever the table is modified or when it is opened. My next tutorial will cover the TODAY() and NOW() functions in detail. Thanks for watching!
@@apple-a-day thank you 🤜🤛
so confusing, Im even more confused after this..never knew Apple is so complicated.
Sorry to hear you're having issues with the complexity. It's not really Apple that's the issue... it's the spreadsheet formulas - they'll be just as complicated on Windows using Excel. Keep plugging away and good luck!
SI([@Date]="";"";RECHERCHEX(MOIS([@Date]);Listes!$C$2:$C$13;Listes!$D$2:$D$13)) This formula was for take a date (year-month-day) in column A2 and search for the month on another table with C1 to C13 for 1-13 and another column for january to december D1 to D13 and choose the right month to put n another clolumn.
But they said that formula have a syntax error ???? Can you help me with that ?
Thx
Hello, it looks like you're using an Excel formula in Numbers. Numbers doesn't understand the @ symbol unfortunately. This is the Implicit Intersection Operator. I'm not sure what the equivalent of that symbol would be in Numbers - I'm not really an Excel user. Sorry I can't be of more help.