Formula for next month

  • Thread starter Thread starter Steved
  • Start date Start date
S

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.
 
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".
 
Hi Steved!

If you have the number 2004 in A2

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