Thread: Date Calculations
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
denileigh[_8_] denileigh[_8_] is offline
external usenet poster
  
Posts: 1
Default Date Calculations

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

Reply With QuoteReply With Quote