#Value! in Month

[Salamullah]

Hi,

I think its a format issue, how to solve ?

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

[TABLE="width: 192"]
<colgroup><col width="64" style="width: 48pt;" span="4"> <tbody>[TR]
[TD="width: 64, bgcolor: transparent, align: left"]Date[/TD]
[TD="width: 64, bgcolor: transparent, align: left"]DD[/TD]
[TD="width: 64, bgcolor: transparent, align: left"]MM[/TD]
[TD="width: 64, bgcolor: transparent, align: left"]YY[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]12/05/19[/TD]
[TD="bgcolor: transparent, align: right"]12[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[TD="bgcolor: transparent, align: right"]2019[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DCE6F1]#DCE6F1[/URL] , align: left"]15/05/19[/TD]
[TD="bgcolor: transparent, align: center"]#VALUE![/TD]
[TD="bgcolor: transparent, align: center"]#VALUE![/TD]
[TD="bgcolor: transparent, align: center"]#VALUE![/TD]
[/TR]
</tbody>[/TABLE]

 

[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 !


[TABLE="width: 102"]
<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>[TR]
[TD="width: 64, bgcolor: transparent, align: left"]12/05/19[/TD]
[TD="width: 72, bgcolor: transparent, align: right"]43804[/TD]
[/TR]
[TR]
[TD="align: left"]15/05/19[/TD]
[TD="align: center"]#VALUE ![/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

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