Create a table in Excel with automatic date insertion
11 USD Task Description: It is necessary to create according to the example (attached to the project) and set up a table in Excel in such a way that when a checkbox is checked in the two columns with the headers "Name 1" and "Name 2" (which need to be added to the document at the place indicated in the example, in the image that I attached to the project with a red arrow) the current date should automatically be inserted in the adjacent cell of the "Data" column where the dates are currently written by hand in the example.
Do not fill in all the text in the example!! It is important to maintain the structure of the document!!
Requirements:
- When a checkbox appears in the "Name 1" and "Name 2" columns, the corresponding cell in the "Data" column should automatically insert the date in the format DD.MM.YYYY.
- If the checkbox in the "Name 1" and "Name 2" columns is unchecked, the cell in the "Data" column should be cleared.
- The formulas and settings should be universal and work in Excel versions starting from 2016.
Expected Result: A table with working functionality, where checking/unchecking the checkbox in the "Name 1" and "Name 2" columns
automatically displays the current date in the "Data" column.
Applications 1
Client's review of cooperation with Anton T.
Create a table in Excel with automatic date insertionAnton is a true professional in his field! The work was done at the highest level, with quality and within the strictly agreed deadlines. I recommend Anton to everyone who values professionalism and responsibility. I would be happy to work with him again!
Freelancer's review of cooperation with Serhii Azikov
Create a table in Excel with automatic date insertionStep by step, we brought the automation to the required condition, the client quickly checked the options and provided feedback.
-
1 day11 USD
812 15 0 1 day11 USD
I will do it, feel free to contact me.
=====================================================
-
1 day11 USD
981 17 0 1 day11 USD
Good day!
I can automate either a local MS Excel file or offer the same automation in Google Sheets. Please reach out - we can discuss the details)
-
1 day11 USD
1713 24 0 1 day11 USD
Hello, Serhiy!
I will gladly fulfill your order.
If you are interested, please send a message to discuss the details.
I would be grateful if you choose me to carry out the project.
-
1 day13 USD
250 37 1 2 1 day13 USD
I will help and complete this task
I am ready to take on the work, write to me
-
1 day11 USD
4461 102 0 1 day11 USD
Good day. I will be happy to help. I will complete everything quickly and efficiently!
-
Winning proposal1 day11 USD
5902 345 0 Winning proposal1 day11 USD
I can do it after agreeing on the required table structure...
-
1 day11 USD
3020 73 4 2 1 day11 USD
Good day! I have a lot of experience working with ET!!!!! Feel free to contact me! I can start right now!!
Dnepr