When we are in the daily office study, sometimes we need to set a time countdown reminder in Excel, in order to make the time in Excel more dynamic and intuitive, we will need to make a countdown updater that will change in Excel, so how to make this automatic update of the countdown timer? Let's share with you how to make it. Excel Tips
Methodological steps
1. Create a new excel**, enter the project name of the countdown in **, and then enter the formula in the cell where the countdown needs to be displayed:=date(2024,5,1)-now(), press the [Enter] key after typing, and you can get the time when the current time is away from 2024 5 1.
Note: date(2024,5,1) indicates that the end of the countdown is 2024 5 1;now() indicates the current time
2. Select the cell to enter the formulaPress CTRL+1 to open the Format Cells dialog box, and then click[Number] - [Custom].on the right".type".fieldd, day, hh, m, m, s, second, and then click OK so that the countdown cell shows the specific countdown days.
3. Click[Development Tools].tab, in the "Bar".Click on "Visual Basic"., open the VBA working interface, and thenClick [Insert] - [Module].to open the Edit window.
4. Enter the ** in the ** window, and then click in the menu bar above VBRun Sub-Procedure (or press F5 directly)., and then close the window, back to the Excel** interface, you can find that the countdown is automatically updated in real time.
Notes:
The style and appearance of the countdown can be set according to your needs.
If you need to open Excel next time the countdown is still updated in real time, you need to record macro settings.