issue with =day(a1) & =month(a1)

[galvinpaddy]

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