Formula for next month

[Steved]

Hello from Steved
A2 = 2004 formated as yyyy
D2 = A2+32 to get Jan formated "mmm"
L2 = D2+32 to get Feb formated "mmm"

Question what is the correct formula for cell D2 to read
Cell A2 and put Jan and L2 and put Feb please.

Thankyou.

 

[Ragdyer]

To obtain "true" XL dates, try:

D2 =DATE(YEAR(A2),1,1)
L2 =DATE(YEAR(A2),2,1)

With, as you have already stated,
Both cells custom formatted to "mmm".

 

[Norman Harker]

Hi Steved!

If you have the number 2004 in A2

D2:
=DATE(A2,1,1)
Format mmm
L2:
=DATE(A2,2,1)
Format mmm

 

[Steved]

Thankyou Ragdyer, Thats done what I required.

Cheers.