Tax Support Home Page | Contact Us | About Us

Online Discussion Forum For UK Tax Professionals and Accountants

Tax Support Forum logo
Welcome Guest! To enable all features please Login or Register.




Go to last post Go to first unread
Offline Josh  
#1 Posted : 21 January 2015 13:23:05(UTC)

Rank: Newbie

Groups: Registered
Joined: 25/09/2014(UTC)
Posts: 3

Was thanked: 1 time(s) in 1 post(s)
Hey Bif

Saw you rounding formula very handy cheers

Here is one I find useful to get the day of the week. i.e. Monday or "Mon" to show which is often very useful to.

Set for formula within the date cell in excel as custom (right click, format cells the custom)

dd mmm yyyy ddd will show as say 05 Apr 2014 Sat

where as dd mmmm yyyy dddd will show as 5 April 2014 Saturday

or you could show is the other way round ddd dd mmm yy would show in excel as Sat 05 Apr 14

4 ds i.e. dddd for the full day of the week
3 ds for abbreviated day of the week

Same for the month

Year yy for say 14 and yyyy for 2014.

If you want the day of the week in a separate column! ;-)

Cell A1 (say) put the date and formulate as you wish, say dd/mmm/yy

the in other cell say B1 use the formula =TEXT(A1,"ddd") for Mon or =TEXT(A1,"dddd") for Monday (say)

Remember the "" around the ddd in the formula as otherwise you will just see and error.


thanks 1 user thanked Josh for this useful post.
Mike on 30/12/2015(UTC)
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

The Tax Support Forum is aimed at UK tax professionals and accountants and it is free to participate.

No responsibility or liability whatsoever is accepted by, Tax Publications Limited or its associates or employees for any posts or comments in this discussion forum. It is meant for help and guidance only and if you are unsure of any aspects of tax we strongly recommend you seek the help of a suitably experienced and qualified professional. Remember that tax legislation changes frequently. Posts on this forum may have been superseded by later legislation or professional practice.

By using the Tax Support website you agree to using cookies. Cookies are small text files stored on your browser when you use websites and applications.

You can control how websites use cookies by configuring the privacy settings within your browser. See your browser help section for more information about cookie controls.

Note that if you disable cookies entirely parts of this website may not function properly.
Privacy Policy - Read more

© 2015 | All Copyright Reserved - A Tax Publications Website