In the new worksheet, Select Edit > Paste Special: If you do, the formulas will be pasted and not the actual values. Select Edit > Copy from your Excel Menu and open a new Excel Worksheet – this will be the worksheet we export to CSV. We may want to come back to this spreadsheet each quarter or each year as we schedule the next social updates. Be sure to save your Excel Spreadsheet (AS Excel) now. There we go! Now we’ve got a column of Monday, Wednesday, and Friday days with random times between 8 am and noon. So, I’m going to insert a column next to column A and then in column B, I’m going to add a random number of house and minutes to the time in column A, but not go past noon: =A2+TIME(RANDBETWEEN(0,3),RANDBETWEEN(0,59),0) Now that we’ve got all of our dates set, we may not want to publish at the exact time. Now, you can just drag the formula for as many updates as you’d like to import. Our next 3 rows are just going to add a week to our calculated fields above. In Excel, we can automatically drag a series of cells for Excel to automatically calculate formulas in later rows. Now, in cell A4, I’m going to add 4 days so that I get the date for Friday: =A2+4 In cell A3, I just need to add 2 days to the Date in A2 to get the date for Wednesday: =A2+2 This formula jumps to the next week and then finds Monday in the week. In cell A2, my formula is to find the first Monday after today. My columns are pretty simple: Date, Text, and URL. Excel Formulas for Calculating Day of Weekīe sure to start with an Excel Spreadsheet, not a CSV file, since we’re going to use Excel Formulas and then export the file to a CSV format. In this example, I’m going to fill the spreadsheet with social media updates for mornings on Mondays, Wednesdays, and Fridays. We want to set the CSV to specific weekdays and some random times each morning. When we build the CSV file, we don’t want to just slam a tweet 7 days a week at the same time. As an observation, they also offer a bit of flexibility when uploading your comma-separated value ( CSV) file because you can map the columns of your file rather than having them hard-coded. Since Agorapulse is a partner of Martech Zone, I’ll walk you through their process. Most social media publishing platforms offer a bulk upload capability to schedule out your social media calendar. Because of this, we like to schedule social media updates far ahead of time. One of the clients that we work with has a fairly consistent seasonality to their business.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |