Dates Math

[Gord]

Hey Folks,

Let's try the simple version - for a calculation in a spreadsheet I
use for tracking sales I need to be able to take the month out of a
date entry.

Right now we have column b which is the date, and then column c which
is the month. Column d is the transaction type and on another sheet i
use cell=sheet1c1&d1 to track what happend when.

I'd love to be able to make the cell on the other sheet pull the month
from B column rather then the redundent entry in C.

Help!

 

[Pete_UK]

If you want the month to be a number, then try this:

=MONTH(B1)

If you want it to be a three letter abbreviation of the name, then try
this instead:

=TEXT(B1,"mmm")

assuming your date is in B1 in both cases and is in Excel date format.

Hope this helps.

Pete

 

[Gord]

If you want the month to be a number, then try this:

=MONTH(B1)

If you want it to be a three letter abbreviation of the name, then try
this instead:

=TEXT(B1,"mmm")

assuming your date is in B1 in both cases and is in Excel date format.

Hope this helps.

Pete







- Show quoted text -

Perfect! Worked like a charm!

 

[Pete_UK]

Well, thanks for feeding back - glad it worked for you.

Pete