The cell im working from is b3. it is formated under "date: march 98" I need just the number of the month to appear in cell c3.
b3= october-04 then c3= 10
b3= november-02 then c3=10
etc..
Any Ideas?
The cell im working from is b3. it is formated under "date: march 98" I need just the number of the month to appear in cell c3.
b3= october-04 then c3= 10
b3= november-02 then c3=10
etc..
Any Ideas?
try =month(b3)
does that work for you?
Bruce
The older I get, the better I used to be.
USA
no that didnt work, i got custom format "M" to work though. Thanks
Hi
One way, in cell C3
=B3 and format cell C3 as Format>Cells>Number>Custom> mm
Regards
Roger Govier
comotoman wrote:
>The cell im working from is b3. it is formated under "date: march 98" I
>need just the number of the month to appear in cell c3.
>
>
>b3= october-04 then c3= 10
>b3= november-02 then c3=10
>etc..
>
>Any Ideas?
>
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks