Adding Suffix to a date variable

[malczyk]

Hello, i've recently learned VBA and really enjoying it. I've managed to automate a large proportion of my job with considerably more accuracy than when i was doing it manually, my manager doesn't know yet though so we'll keep that on the down low for a while. Anyway i've basically got the core part of my spreadsheet working well but am having trouble with adding suffix's (st, nd, rd, th) to a date function. The code i've put together can be seen below. Basically when i add a new sheet every week it copies the old one and corrects all the equations, which works fine, and then it adds week commencing and that Monday's date to a cell at the top, which also works fine. But no matter what I try I only get 'st' after the day number and this is the part I have the issue with. Can anyone have a go at correcting my code? Also, if you could explain why my code was going wrong that would be really helpful - always aiming to learn from my mistakes.

Please Login or Register  to view this content.

Thanks Andrew

[jindon]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

try one of the folloiwngs

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[malczyk]

Sorry about the code box I was unaware.

The top one worked perfectly thanks.

[jindon]

You are welcome and thanks for the code tag.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.