You could see here it takes a start date and an end date but also a list of excluded dates. So between January 1st and December 31st there are 261 work days. But you could also exclude certain holidays. Workdays would be weekdays, basically, not including the weekends. There are some special functions though to deal with Work Days. So you can take a date like March 28, 2021, add ten days to it, just simple addition, no function needed and you'll get the date ten days from that current date. Now you can also Add and Subtract durations from a date. So if that's your birthday that's how old you are in days. Here I'm subtracting NOW, which is a function that will return the time right now, from Jand I get 16687 days. It doesn't make sense to add dates but it does make sense to subtract them. Now you can also subtract dates to get a duration. Type 4h space 38m and you'll get a duration. To create these durations you just need to type them exactly like this. Notice that this is just simple addition here.
FUN THINGS YOU CAN DO WITH IMOVIE ON MAC PLUS
Here we're adding three weeks to two days and 17 hours plus 10d and 10h to get 4 weeks, 6 days, 3 hours. So you can add these two durations together to get 7 hours and 23 minutes. Durations are represented with a single letter to represent the unit. Now a lot of people don't know that you can also work with Durations in Numbers. That one takes a value that already has a currency in front of it, like this one here, Euros and it converts it to another currency, USD here, and it gives us our one dollar back. There's also, as you can see here, a currency convert function. If you need to get some sort of fund or a foreign stock find out how Yahoo Finance represents that stock and use that same thing in the Stock or StockH function. So if you don't know the correct three letters used for a currency go to the Yahoo Finance website and look it up there. If you look at the Help here you'll see that the values come from Yahoo Finance. It shows that the one US dollar is 0.82 Euros accurate to the current day. So in this case USD, for US dollars, to EUR or Euros. So you can use the Currency function to convert from one currency to another. Now you can also do Currency Conversions. Make sure it's a date that the market was actually open. So in addition to the stock value and what you want, like Close or Open or Volume, you also give a date. Also there's a StockH function to give you stock history. You get things like Change, Open, High, Low, Market Cap, Volume, Yield. If you look at the function help for Stock you'll see there's a lot more that you can do with it. So it's now a live to the minute stock value. Just give it the symbol, like APPL for Apple, and you get the previous market day's close for that stock.
All you need to do to get a stock quote is use the Stock function. Stock Quotes has been around for awhile in Numbers but some people still don't know they are there. Join us and get exclusive content and course discounts. There you can read more about the Patreon Campaign.
MacMost is brought to you thanks to a great group of more than 800 supporters. Today let me show you some things that you might not know that you can do in Numbers. Video Transcript: Hi, this is Gary with.
FUN THINGS YOU CAN DO WITH IMOVIE ON MAC MAC
Check out 25 Things You Didn’t Know You Could Do With Mac Numbers at YouTube for closed captioning and more options.
0 kommentar(er)
