Hello & Good morning happy campers,
I am trying to get a sheet to do the following.
In A1 i put todays date (29/11/2012)
In B1 i put =day(a1)
In C1 i put =month(a1)
In D1 i put =year(a1)
In B1 unformatted shows 29 - correct if going on todays date.
BUT
B1 - format to DDDD it shows SUNDAY (or SUN when formatted as DDD)
C1 unformatted shows 11, when i custom format to show as MMMM it shows January (or when formatted to MMM shows JAN), when it should read November, can anyone tell me what im doing wrong / not doing?
Kind regards
Bookmarks