navinrb
Board Regular
- Joined
- Jun 9, 2020
- Messages
- 82
- Office Version
- 2019
- Platform
- Windows
- Mobile
- Web
I want to know if there is any way to auto fill year or month as i enter only day.i have many dates with same month and year but with different days so i don't want to write full date format.
For example if i input 05 and press enter..it should automatically set date as 05-01-2020
If i enter 07 ..output should be 07-01-2020 ..and so on.
So basically i mean i just want to enter day but month and year is autofilled
Thanks in advance.
For example if i input 05 and press enter..it should automatically set date as 05-01-2020
If i enter 07 ..output should be 07-01-2020 ..and so on.
So basically i mean i just want to enter day but month and year is autofilled
Thanks in advance.