Skip to main content

Conas an lá nó an mhí nó an bhliain reatha a chur isteach i gcill in Excel?

Nuair is mian leat an mhí reatha nó an dáta reatha a chur isteach go tapa in Excel, conas is féidir leat a chur isteach? Cuideoidh an modh seo a leanas leat an mhí nó an dáta reatha a chur isteach i gcill go tapa, nó i gceanntásc / buntásc na bileoige oibre.

Cuir isteach an bhliain, an mhí nó an dáta reatha de réir foirmlí agus hotkeys in Excel

In Excel, is féidir leat an bhliain reatha, an mhí, an dáta agus na stampaí ama a chur isteach le foirmlí go héasca.

Tóg an mhí reatha a chur isteach mar shampla, clóscríobh an fhoirmle le do thoil MÍ (TODAY ()) sa chill is mian leat an mhí reatha a chur isteach agus brúigh Iontráil.

  Foirmle  Filleann an fhoirmle
Cuir isteach an mhí reatha MÍ (TODAY ()) 8
Cuir isteach an mhí reatha = TEXT (TODAY (), "MMMM") Lúnasa
Cuir isteach an Bhliain Reatha = BLIAIN (TODAY ()) 2015
Cuir isteach an dáta reatha = TODAY () 2015/8/20
Cuir isteach Dáta agus am reatha ANOIS () 2015/8/20 9:41

Is féidir le hotkeys cabhrú leat an dáta agus an t-am reatha a chur isteach go héasca:

(1) Brúigh CTRL +; eochracha chun an dáta reatha a chur isteach.

(2) Brúigh CTRL +; chun an dáta reatha a chur isteach ar dtús agus na heochracha a scaoileadh, ansin brúigh Spás cnaipe chun spás a chur isteach, sa phreas deireanach CTRL + SHIFT +; chun an t-am reatha a chur isteach.

ribín nóta Tá an fhoirmle ró-chasta le cuimhneamh? Sábháil an fhoirmle mar iontráil Auto Text le haghaidh athúsáid agus gan ach cliceáil amháin sa todhchaí!
Léigh níos mó ...     Triail saor in aisce

Cuir isteach an bhliain, an mhí nó an dáta reatha le formáidiú dáta speisialta

Má tá tú Kutools le haghaidh Excel suiteáilte, a Dáta Ionsáigh is féidir le fóntais cabhrú leat an mhí nó an dáta reatha a chur isteach go tapa le formáidiú dáta éagsúla agus gan ach cúpla cad a tharlaíonn in Excel.

Kutools le haghaidh Excel - Supercharge Excel le níos mó ná 300 uirlisí riachtanacha. Bain sult as triail iomlán 30-lá SAOR IN AISCE gan aon chárta creidmheasa ag teastáil! Get sé anois

Tar éis duit Kutools a shuiteáil le haghaidh Excel, déan na céimeanna seo a leanas le do thoil:

1. Roghnaigh cill ar mhaith leat a chur isteach sa bhliain, sa mhí nó sa lá reatha, agus cliceáil ar an Kutools > Ionsáigh > Dáta Ionsáigh, féach ar an scáileán:

2. Sa an Dáta Ionsáigh dialóg, seiceáil an Ag úsáid formáid rogha, agus ansin cliceáil faoi dhó ar fhormáidiú dáta sa phána ceart. Féach an pictiúr thuas:

Anois cuirtear an dáta reatha isteach i gcill ghníomhach leis an bhformáid dáta sonraithe.

nótaí: De réir réamhshocraithe roghnaítear an dáta reatha san fhéilire sa bhosca dialóige Ionsáigh Dáta. Más gá duit dáta eile a chur isteach, ní mór duit an dáta san fhéilire a roghnú ar dtús.

Kutools le haghaidh Excel - Supercharge Excel le níos mó ná 300 uirlisí riachtanacha. Bain sult as triail iomlán 30-lá SAOR IN AISCE gan aon chárta creidmheasa ag teastáil! Get sé anois

Cuir isteach Dáta agus am reatha i gcill / ceanntásc / buntásc le Kutools le haghaidh Excel

Má tá Kutools for Excel suiteáilte agat, tá a Cuir isteach Eolas faoin Leabhar Oibre cuireann fóntais ar do chumas an dáta agus an t-am reatha a chur isteach i gcill / ceanntásc / buntásc go héasca. Déan mar a leanas le do thoil:

Kutools le haghaidh Excel - Supercharge Excel le níos mó ná 300 uirlisí riachtanacha. Bain sult as triail iomlán 30-lá SAOR IN AISCE gan aon chárta creidmheasa ag teastáil! Get sé anois

1. Cliceáil ar an Kutools Plus> Leabhar Oibre > Cuir isteach Eolas faoin Leabhar Oibre.

2. Sa bhosca dialóige oscailte Ionsáigh Faisnéis Leabhar Oibre, seiceáil an Dáta agus am reatha rogha, sa Ionsáigh ag roinn sonraigh seasamh, agus cliceáil an Ok cnaipe. Féach an pictiúr thuas:

Ansin cuirtear dáta agus am reatha isteach sa chill, ceanntásc nó buntásc sonraithe ag an am céanna.

Kutools le haghaidh Excel - Supercharge Excel le níos mó ná 300 uirlisí riachtanacha. Bain sult as triail iomlán 30-lá SAOR IN AISCE gan aon chárta creidmheasa ag teastáil! Get sé anois

Taispeántas: cuir isteach an lá, an mhí, nó an bhliain reatha i gcill / ceanntásc / buntásc in Excel


Kutools le haghaidh Excel: Breis is 300 uirlis láimhe ar do mhéar! Cuir tús le do thriail saor in aisce 30-lá gan aon srianta gné inniu. Íosluchtaigh Anois!

Alt coibhneasta:

Cuir isteach an dáta reatha go tapa le formáid dáta ar leith

Uirlisí Táirgiúlachta Oifige is Fearr

🤖 Kutools AI Aide: anailís sonraí a réabhlóidiú bunaithe ar: Forghníomhú Chliste   |  Gin Cód  |  Cruthaigh Foirmlí Saincheaptha  |  Anailís a dhéanamh ar Sonraí agus Cairteacha a Ghin  |  Feidhmeanna Kutools a agairt...
Gnéithe Coitianta: Faigh, Aibhsigh nó Aithnigh Dúblaigh   |  Scrios Sraitheanna Bána   |  Comhcheangail Colúin nó Cealla gan Sonraí a Chailleadh   |   Babhta gan Foirmle ...
Cuardaigh Super: Ilchritéir VLookup  |   VLookup Illuachanna  |   VLookup Trasna Ilbhileoga   |   Amharc doiléir ....
Liosta anuas Casta: Go tapa Cruthaigh Liosta Anuas   |  Liosta anuas Cleithiúnach   |  Liosta Buail Isteach Ilroghnacha ....
Bainisteoir Colún: Cuir Líon Sonrach Colún leis  |  Colúin Bog  |  Scoránaigh Stádas Infheictheachta na gColún Ceilte  |  Déan comparáid idir Raonta & Colúin ...
Gnéithe Réadmhaoin: Fócas Eangaí   |  Amharc Dearaidh   |   Barra Mór na Foirmle   |  Leabhar Oibre & Bainisteoir Bileog   |  Leabharlann Acmhainní (Uaththéacs)   |  Piocálaí Dáta   |  Comhcheangail Bileoga Oibre   |  Criptigh/Díchriptigh Cealla   |  Seol Ríomhphost trí Liosta   |  Scagaire Super   |   Scagaire Speisialta (scagaire trom/iodálach/stailc tríd...) ...
Barr 15 Uirlisí:  12 Téacs uirlisí (Cuir Téacs, Bain Carachtair,...)   |   50 + Cairt cineálacha (Cairt Gantt,...)   |   40+ Praiticiúil Foirmlí (Ríomh aois bunaithe ar lá breithe,...)   |   19 Insertion uirlisí (Cuir isteach Cód QR, Ionsáigh Pictiúr ón gCosán,...)   |   12 Tiontú uirlisí (Uimhreacha le Focail, Comhshó Airgeadra,...)   |   7 Cumaisc & Scoilt uirlisí (Sraitheanna Comhcheangail Casta, Cealla Scoilt,...)   |   ... agus eile

Supercharge Do Scileanna Excel le Kutools le haghaidh Excel, agus Éifeachtúlacht Taithí Cosúil Ná Roimhe. Kutools le haghaidh Excel Tairiscintí Níos mó ná 300 Ardghnéithe chun Táirgiúlacht a Treisiú agus Sábháil Am.  Cliceáil anseo chun an ghné is mó a theastaíonn uait a fháil ...

Tuairisc

Tugann Tab Oifige comhéadan Tabbed chuig Office, agus Déan Do Obair i bhfad Níos Éasca

  • Cumasaigh eagarthóireacht agus léamh tabbed i Word, Excel, PowerPoint, Foilsitheoir, Rochtain, Visio agus Tionscadal.
  • Oscail agus cruthaigh cáipéisí iolracha i gcluaisíní nua den fhuinneog chéanna, seachas i bhfuinneoga nua.
  • Méadaíonn do tháirgiúlacht 50%, agus laghdaíonn sé na céadta cad a tharlaíonn nuair luch duit gach lá!
Comments (27)
No ratings yet. Be the first to rate!
Larry Kiser
Larry Kiser
This comment was minimized by the moderator on the site
In EXCEL 365, I want to insert the month based on cell A2 along with a text string in the header.
Reply
Report
0
0
kellytte
kellytte     Larry Kiser
This comment was minimized by the moderator on the site
Hi Larry,
Do you want to extract the month name from Cell A2 which is filled with date and text string? Or extract month name from Cell A2 and output the month nae and text string together?
Reply
Report
0
0
Larry Kiser
Larry Kiser
This comment was minimized by the moderator on the site
I want to insert the month based on cell A2 along with a text string.
Reply
Report
0
0
Nina
Nina
This comment was minimized by the moderator on the site
=TEXT(MONTH(TODAY()),"mmmm") gives me January, although it is now February. What is wrong with this formula?
Reply
0
0
Julia
Julia     Nina
This comment was minimized by the moderator on the site
Take MONTH out of the formula:
=TEXT(TODAY(),"MMMM")
Reply
0
0
nu
nu
This comment was minimized by the moderator on the site
how to get current month only in header/footer
Reply
0
0
kelly001
kelly001     nu
This comment was minimized by the moderator on the site
No normal ways can get current month in header or footer in Excel. But VBA can:

Sub add_date_header()
ActiveSheet.PageSetup.CenterHeader = Format(Date, "mmmm")
End Sub
Reply
Report
0
0
rizq
rizq
This comment was minimized by the moderator on the site
Hi all, I need a formula to COUNT all the records from previous months and years from a single column source. Can someone please help me for this?
For Example, I have dates in A column, but I want to get the COUNT not sum, of the only dates which are from previous month or year.
Reply
Report
0
0
kelly.extendoffice@gmail.com
    rizq
This comment was minimized by the moderator on the site
Hi,
The topic of this article is about inserting the current date, month, or year.
Reply
Report
0
0
MR CK YEOH
MR CK YEOH
This comment was minimized by the moderator on the site
HOW DO I GET THE PREVIOUS MONTH AND YEAR IN THE SAME CELL
Reply
0
0
Tech Support
Tech Support     MR CK YEOH
This comment was minimized by the moderator on the site
Hi,
=YEAR(TODAY())&"/"&(MONTH(TODAY())-1)

This formula will return year and previous month in the formatting of “2017/8”
Reply
0
0
May
May
This comment was minimized by the moderator on the site
how do I get Current Month and Year in the same cell =TEXT(TODAY(),"MMMM") August =YEAR(TODAY()) So using the Above how would I get December, 2016 format?
Reply
0
0
Satyam MISHRA
Satyam MISHRA     May
This comment was minimized by the moderator on the site
=+TEXT(TODAY(),"mmm")&"-"&(YEAR(TODAY()))
Reply
0
0
Jayadev BS
Jayadev BS     May
This comment was minimized by the moderator on the site
=CONCATENATE(TEXT(TODAY()," MMMM"), ", ", YEAR(TODAY()))
Reply
0
0
MAnis
MAnis     Jayadev BS
This comment was minimized by the moderator on the site
Instead you can simply
=TEXT(TODAY(),"MMM,YYYY")
Reply
0
0
abhay
abhay     Jayadev BS
This comment was minimized by the moderator on the site
thanks a lot..this formula works exactly what we need
Reply
0
0
Brad
Brad     abhay
This comment was minimized by the moderator on the site
This formula worked great, but one question how would I adjust this formula to show the previous month and year instead of the current month and year.=CONCATENATE(TEXT(TODAY()," MMMM"), ", ", YEAR(TODAY()))
Reply
0
0
Jayadev BS
Jayadev BS
This comment was minimized by the moderator on the site
#1: Check your machine date #2: check =TODAY()
Reply
0
0
Sarah
Sarah     Jayadev BS
This comment was minimized by the moderator on the site
[quote]#1: Check your machine date #2: check =TODAY()By Jayadev BS[/quote] ^^ this returns the correct date but I still have the issue with =year(today()) it returns a full date but in 1905 (eg. 07/08/1905)
Reply
0
0
Sarah
Sarah
This comment was minimized by the moderator on the site
year(today()) formula return a date in 1905... Send Help!
Reply
0
0
purchasing
purchasing
This comment was minimized by the moderator on the site
I am trying to use this function to return values for projected month sales. I have tried to use this formula to return a value for two months past the current month but it is only returning the value for Dec when Nov is the current month rather than January. Can somebody please help? =VLOOKUP(MONTH(current_date+2),MA_Prod_Forecasting,5)
Reply
0
0
There are no comments posted here yet
Load More
Please leave your comments in English
Guest
Posting as Guest
×
Rate this post:
Reset
0   Characters
Suggested Locations