View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Date Calculations

Hard to tell what you are doing, but if I format the cell as MM and put in
an actual date, then in the immediate window, these queries show the
situation:

? activecell.Text
02
? activecell.NumberFormat
mm
? activecell.Value2
38760
? activecell.Value
2/12/2006


so the actual number stored in the cell is 38760 which is the date serial
for the date I entered 2/12/2006.

If you want to multiply by the month number then (assume the cell is B9) use

=month(b9)*283.8

--
Regards,
Tom Ogilvy

"denileigh" wrote
in message ...

Simple Question I hope.....not for me obviously.

I have a field that puts in the current month formatted as 02. I need
to take that number and multiply it by a payment to get a current
balance due for the year.

For example 02 (current month) x 283.8 (payment) = 567.60

Right now the date format in the 02 is returning a goofy number.

Any ideas?

THANKS!


--
denileigh
------------------------------------------------------------------------
denileigh's Profile:

http://www.excelforum.com/member.php...o&userid=30211
View this thread: http://www.excelforum.com/showthread...hreadid=516891