I have date with a date and time. I just want the date

Dear @Steven C,

Based on your description, I understand that the value you’re working with includes both a date and time (for example, 4/09/26, 11:30:46 AM), and you’d like to extract just the date.

First of all, I see your value is "4/09/26, 11:30:46 AM", please make sure there isn’t any comma (",") in your data. Sometimes that comma indicates the value is stored as text instead of a real datetime, which will affect how formulas behave.

Then, if your value is in cell A1 and you want the result to display in dd/mm/yyyy format, you can simply format the cell by pressing Ctrl + 1, selecting Custom, and in the Type, entering dd/mm/yyyy. This will keep the value as a proper date that you can still use in calculations.

Otherwise, if you refer to use formular, you can use =TEXT(A1,"dd/mm/yyyy") instead.

I hope the information shared is helpful. Please try the steps above and let me know if they work. If not, we can continue working together to narrow this down.

The first response may not always resolve the issue right away, but with your help and more details, we can work toward a solution.

Thank you for your patience and understanding. I'm looking forward for your reply.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

You can extract just the date from a datetime string in Excel and format it as dd/mm/yyyy using the TEXT function. Assuming your datetime is in cell A1, here’s the formula:

=TEXT(A1, "dd/mm/yyyy")

• A1 is the cell with your full datetime (4/09/26, 11:30:46 AM)
• "dd/mm/yyyy" formats it to day/month/year, e.g., 04/09/2026

This will display only the date without the time.

If you want it as an Excel date (not text) so you can perform calculations, use:

=INT(A1)

Then format the cell with Custom Format → dd/mm/yyyy.

This approach ensures proper date sorting and calculations.

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin