How can I get Excel to recongnize the displayed number value from a EOMONTH command?

[furstukin]

I have a spreadsheet that tells me the start of the fiscal month in one cell (F3) and in another cell (H3) tells me the number of days in that fiscal month by using a "=EOMONTH(F3,0)" formula. Currently I have to take the number displayed in H3 and manually enter it into another cell so my sheet will properly calculated the remaining days of the month (anything after 28).

So is there a way to get excel to just recognize the number my formula in H3 displays? Currently if I copy value it gives me the value for the date that the end of the month falls on. For instance I have it set to 6/22/11 for the fiscal month and the EOMONTH is 6/30/11 so the value displaed is 40724. I have also tried "=TEXT(H3,%)" where % is about any format I could think of to try but it never works.

Any help is appreciated. Thanks

 

[RoryA]

If you just want the day number, then =DAY(H3)

 

[shg]

What do you want it to show?

 

[furstukin]

If you just want the day number, then =DAY(H3)

Yes that was exactly what I wanted. Now it is looking at the cell as the value that is displayed by the EOMONTH formula. Thank you very much for your quick response.