#Value! in Month

[Salamullah]

Hi,

I think its a format issue, how to solve ?

formula applied in B2 =DAY(A2) C2 =MONTH(A2)

Date	DD	MM	YY
12/05/19	12	5	2019
15/05/19	#VALUE!	#VALUE!	#VALUE!

<colgroup><col width="64" style="width: 48pt;" span="4"> <tbody> </tbody>

 

[Fluff]

Sounds like some of your dates are text, select the cells with the dates & change the format to "General", you should see numbers like 43600
Do you?

 

[Salamullah]

yes its 43600 how to change it to 15 05 19 ?

 

[Fluff]

If it shows 43600 then it's a proper date & your formulae should work.
To change the display to a date, just change the format to short date

 

[Salamullah]

My report is giving like below looks when figure is more than 12 its showing #VALUE !

12/05/19	43804
15/05/19	#VALUE !

<colgroup><col width="64" style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;"> <col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <tbody> </tbody>

 

[Fluff]

does 15/05/19 change to 43600 when you change the format to "General" or does it still display 15/05/19?