Fomula ya Excel Yokonzekera Zosintha Zosiyanasiyana Patsiku la Sabata

Excel - pangani Hootsuite kapena Agorapulse Social Media Import ya Twitter

Mmodzi mwa makasitomala omwe timagwira nawo ntchito amakhala ndi nyengo yofananira kubizinesi yawo. Chifukwa cha izi, timakonda kukonzekera zosintha zapa media pasadakhale kuti asadandaule za kugunda masiku ndi nthawi.

Makanema ambiri osindikiza atolankhani amapereka kuthekera kokulirapo kuti athe kukonza kalendala yanu yapa media. Kuyambira Agorapulse ndiwothandizira wa Martech Zone, Ndikukuyendetsani mnjira zawo. Monga chowonera, amaperekanso kusinthasintha pang'ono mukamayika fayilo yanu yamtengo wapatali (CSV) chifukwa mutha kupanga mapu a fayilo yanu m'malo mongokhala ndi zilembo zolimba.

Tikamapanga fayilo ya CSV, sitikufuna kungolemba tweet masiku 7 pa sabata nthawi yomweyo. Tikufuna kuyika CSV kumapeto kwamasabata komanso nthawi zina m'mawa uliwonse. Mwa ichi, ndikudzaza spreadsheet ndimasinthidwe azama media m'mawa m'mawa Lolemba, Lachitatu, ndi Lachisanu.

Mafomu a Excel Owerengera Tsiku la Sabata

Onetsetsani kuti mwayamba ndi Excel Spreadsheet, osati fayilo ya CSV, popeza tigwiritsa ntchito Mafomu a Excel ndiyeno mutumize fayiloyo ku mtundu wa CSV. Mizati yanga ndiyosavuta: Date, Malembandipo ulalo. Mu selo A2, njira yanga ndikupeza Lolemba loyamba lero. Ndikonzeranso nthawi mpaka 8 koloko m'mawa.

=TODAY()+7-WEEKDAY(TODAY()+7-2)+TIME(8,0,0)

Njirayi imadumphira sabata yamawa ndikupeza Lolemba sabata. Mu selo A3, ndikungofunika kuwonjezera masiku awiri pa Deti mu A2 kuti ndipeze tsiku Lachitatu:

=A2+2

Tsopano, mu selo A4, ndiwonjezera masiku 4 kuti ndipeze tsiku Lachisanu:

=A2+4

Sitinathebe. Mu Excel, titha kukoka maselo angapo kuti Excel izitha kuwerengera mayankho m'mizere yotsatira. Mizere yathu yotsatira itatu ingowonjezera sabata m'minda yathu yowerengedwa pamwambapa. A3, A5, A6, A7, A8, ndi A9 motsatana:

=A2+7
=A3+7
=A4+7
=A5+7
=A6+7
=A7+7

Tsopano, mutha kungokoka chilinganizo cha zosintha zambiri momwe mungafune kutumizira.

kupambana kwambiri masabata

Nthawi Zosasintha mu Excel

Tsopano popeza tili ndi masiku athu onse, mwina sitikufuna kufalitsa nthawi yake. Chifukwa chake, ndiyika gawo pafupi ndi gawo A kenako m'mbali B, ndikuwonjezera nyumba ndi mphindi mwachisawawa munthawi ya A, koma osadutsa masana:

=A2+TIME(RANDBETWEEN(0,3),RANDBETWEEN(0,59),0)

Tsopano ingokokerani fomuyi kuchokera ku B2:

kupambana kuwonjezera nthawi

Pamenepo tikupita! Tsopano tili ndi gawo Lolemba, Lachitatu, ndi Lachisanu masiku osavuta pakati pa 8 koloko masana. Onetsetsani kuti mwasunga Excel Spreadsheet (AS Excel) tsopano. Titha kufuna kubwerera ku spreadsheet iyi kotala iliyonse kapena chaka chilichonse pamene tikukonzekera zosintha zotsatirazi.

Kutsanzira Makhalidwe mu Excel

Sankhani Sinthani> Koperani kuchokera pa Excel Menyu yanu ndikutsegula tsamba la Excel - ili ndiye tsamba lomwe timatumiza ku CSV. Osayika pamtundawu panobe. Mukatero, ndondomekoyi idzaphatikizidwa osati malingaliro ake enieni. Mu worksheet latsopano, Sankhani Sinthani> Sakani Mwapadera:

kupambana koperani pangani menyu apadera

Izi zimapereka zenera pomwe mungasankhe zomwe mukufuna:

pezani kukopera pamiyeso yapadera

Kodi idayika nambala ndi decimal? Palibe nkhawa - muyenera kungolemba danga ngati tsiku ndi nthawi.

kupambana ma cell amtundu nthawi

Ndipo tsopano muli ndi zomwe mukufuna! Mukutha tsopano kukhala ndi zosintha pagulu komanso kuwonjezera maulalo. Pitani ku Fayilo> Sungani Monga ndi kusankha Makhalidwe Osiyanasiyana a Comma (.csv) monga anu Mtundu wa failo. Ndiye ameneyo kukweza zambiri fayilo yomwe mutha kuyitanitsa mu makina anu ochezera.

kukweza zambiri csv

Ngati mukugwiritsa ntchito Agorapulse, mutha kugwiritsa ntchito mawonekedwe awo a Bulk Upload kuti muzitsatira ndikusintha zosintha zanu

Momwe Mungasinthire Zambiri Zosintha Zagulu ku Agorapulse

Kuwulula: Ndine ndine Agorapulse Kazembe.

Mfundo imodzi

  1. 1

Mukuganiza chiyani?

Tsambali likugwiritsa ntchito Akismet kuchepetsa spam. Phunzirani momwe deta yanu ikufotokozera.