Exact Date between the days in a month, across a month and between years

Hi and Hello there
Need you support on how to apply formula to get exact dates.
When I try the functions, Day, Edate, i get date less one day.