1. Accueil
  2. Car News
  3. How to automatically generate the day of the week for not

How to automatically generate the day of the week for not

nicad 01/08/2021 643

Many friends asked, NOTON DATABASE tables can not be generated on the date of date, the answer is ok, to use the formula format in the form, not much nonsense, start below.

This paper template is derived from @, NOTION operation tutorial | Multifunction card calendar with Notion _ (゜ - ゜) つ ロ ロ ~ -bilibili. If there is an unclear template how to make or not use the usage method, it is recommended to look at the new hand | From 0 to 1, Notion Basics Full Guide _ (゜ - ゜ - ゜) つ ロ Cheers ~ -bilibili and @ Other tutorials. The tutorial is very good, this article has not described it.

How to automatically generate the day of the week for not  当然,插入列可以自己随意插入How to automatically generate the day of the week for not  列的格式选择FormulaHow to automatically generate the day of the week for not

The code is as follows (Everyone should pay attention not to copy space, especially if there is a space to delete if there is a space):

Replace (Concat ("Week", Format (DAY ("Date") - 1, 7) + 1)), "0", "7")

How to automatically generate the day of the week for not  像这样就完成啦

The effect picture is as follows

How to automatically generate the day of the week for not  用周1-周7替代周一-周日了,虽然不太符合习惯但不影响使用。主要是notion函数太少,做成中文的太麻烦了

Below is a lazy advanced method to automatically generate today's date

Still, like the above, add a column of Formula

Enter formatdate in the formula (now (), "YYYY / MM / DD")

Effect

How to automatically generate the day of the week for not

The disadvantage is that you can only record the time of the new record, you can't modify it! ! (But for some classmates, you can't modify yourself to add more restrictions, you can't drag them again, maybe you can play the role of supervision, everyone chooses it)


PREV: How do you diagnose a car battery failure?

NEXT: Les 20 SUV compacts hybrides rechargeables du salon Caradisiac Electrique/hybride 2021: quel modèle choisir ?

Articles populaires

Articles chauds
  • Développée pour participer au championnat d’endurance américain IMSA, la Porsche 962 est un prototype qui utilise un moteur 6 cylindres à plat. Elle devient 962C en adoptant une double suralimentation...

  • 2021 est terminée, mais les meilleures ligues de football du monde font à peine la moyenne de leurs tournois et la Ligue des champions promet certains des matchs les plus compétitifs de 2022. Peu importe si vous êtes fan de R...

  • Buy the vehicle before the end of the contract To end your leasing contract, you have the option of buying your car before the end of the lease if you have subscribed for a leasing with option to...

  • 1. Preparing for a sale: The first thing to do to sell a car is to prepare for the sale. For this you need to gather all the documents relating to your automobile. Check that your technical inspec...

  • How to request a duplicate? The request for a duplicate registration card must be made by the owner of the vehicle. If the car is pledged or under a leasing contract, the loss of your certificate...

Retour au sommet