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.
Handy!
Josh
|
 1 user thanked Josh for this useful post.
|
|
|
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.