Thread: Date Calculations
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Date Calculations
Sure that is what you meant:

? MONTH(02)
1

Perhaps you meant

=Month(B9)*283.8

where B9 holds a date (and displays 02) [ as an example ]

--
Regards,
Tom Ogilvy

wrote in message
oups.com...
Hello,

Use
=MONTH(02) * 283.8

HTH,
Bernd



Reply With QuoteReply With Quote