hardeep.kanwar
New Member
Hi All
i have formula "="Updated Joyride Program Summary Till Dated -"&TEXT(TODAY()-1,"DD-MMM-YYYY")&" "&"Cumulative"
and the result is "
Updated Joyride Program Summary Till Dated -25-Jul-2017 Cumulative
"
What i need to Add "th" or "rd" after the Day
For Example
23rd or 25th or 22nd
Updated Joyride Program Summary Till Dated -25th -Jul-2017 Cumulative
Updated Joyride Program Summary Till Dated -23rd -Jul-2017 Cumulative
Updated Joyride Program Summary Till Dated -22nd -Jul-2017 Cumulative
Thanks in Advance
i have formula "="Updated Joyride Program Summary Till Dated -"&TEXT(TODAY()-1,"DD-MMM-YYYY")&" "&"Cumulative"
and the result is "
Updated Joyride Program Summary Till Dated -25-Jul-2017 Cumulative
"
What i need to Add "th" or "rd" after the Day
For Example
23rd or 25th or 22nd
Updated Joyride Program Summary Till Dated -25th -Jul-2017 Cumulative
Updated Joyride Program Summary Till Dated -23rd -Jul-2017 Cumulative
Updated Joyride Program Summary Till Dated -22nd -Jul-2017 Cumulative
Thanks in Advance