Hi Experts
I have dates in two cells in an Excel table and i need to combine them both into another cell with a hyphen to separate them
Could someone please help me. I have attached a test file
Thanks
Regards
Rahul
Hi Experts
I have dates in two cells in an Excel table and i need to combine them both into another cell with a hyphen to separate them
Could someone please help me. I have attached a test file
Thanks
Regards
Rahul
Try below formula in D5
=TEXT(B5,"DD-MM-YYYY")&" - "&TEXT(C5,"DD-MM-YYYY")
or
=TEXT([@[Pay Period - From]],"DD-MM-YYYY")&" - "&TEXT([@[Pay Period - To]],"DD-MM-YYYY")
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Hi Samba
It works perfectly for what I need
Thanks
Regards
Rahul
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks