How to auto fill Year or month ?

[navinrb]

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.

 

[alansidman]

Will it always be January and 2020?

 

[navinrb]

Will it always be January and 2020?

No.it would be different. For eg i have hundreds of sale for March 2019. I need to manually enter all invoice dates. So I just want to input only day of sale but month and year should be autfilled. If day of sale is 2nd march i just want to enter 02 but month and year i.e 03-2019 should be autofilled. Is that possible?

 

[navinrb]

Will it always be January and 2020?

Can i custom format as" d-03-2019 " ?

 

[hnsd24_CN]

You can use Auxiliary cells,just change D1,Then paste date as Values(V)

union.xlsm
	A	B	C	D
1	01-03-2019	2019	3	1
2
3
4
5
6
Sheet2

Cell Formulas
Range	Formula
A1	A1	=TEXT(DATE(B$1,C$1,D$1),"dd-mm-yyyy")

 

[navinrb]

You can use Auxiliary cells,just change D1,Then paste date as Values(V)

union.xlsm
	A	B	C	D
1	01-03-2019	2019	3	1
2
3
4
5
6
Sheet2

Cell Formulas
Range	Formula
A1	A1	=TEXT(DATE(B$1,C$1,D$1),"dd-mm-yyyy")

Sorry that's not what i am looking for.You might be unlear about my question. It seems my query not possible with excel.