Enter a day number, and show day/month/year from another cell

[MKB]

Hi,

I’m getting tired of entering dates into a spreadsheet. I have a master date for each month (example: 1/1/2020) and want to create a formula so as I enter 5, the cell with the formula will show 5/1/2020 - relevant to the month/year of the master cell.

I tried the DATE formula but could only get it to work for January of current year, and similarly linking to a master cell returned a num error. I don’t think that’s the right approach. Any tips please?

Thanks

 

[Peter_SSs]

Is this the sort of thing you mean? If not, more details & examples & layout please.

Master date is in E1
Enter day in column D, formula in E2 is copied down.

Excel Workbook
	D	E
1		1/01/2020
2	5	5/01/2020
3	25	25/01/2020
Date

 

[MKB]

Oh wow, simple. This solved it, thanks.

 

[Peter_SSs]

Oh wow, simple. This solved it, thanks.

You're very welcome. Thanks for the confirmation.