Macro to change date to mm/dd/yyyy when inputtting date in format dd/mm/yyyy

[howard]

I have a macro to input dates in Cell P2 & P3 , which is in format dd/mm/yyy. I macro for the sheet "Inventory" to change the dates automatically to mm/dd/yyy once the date has been inputted

 Sub Date_Range()
With Sheets("Refloorplanned Payout")
that will change
Dim i As Date
 A = InputBox("Please Enter start date range e.g. 08/01/2020")

.Range("P2").Value = A

 B = InputBox("Please Enter end date e.g. 10/01/2020")

.Range("P3").Value = B


End With

End Sub

Your assistance is most appreciated

 

[CountTepes]

Format the cells, where you are putting the date as mm/dd/yyyy

 

[howard]

Thanks for the advice. Did not realise how simple it was