View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pranav Vaidya Pranav Vaidya is offline
external usenet poster
 
Posts: 180
Default Counting Days or Months

Hi Chris,

Try function days360()
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Not Excelerated" wrote:

Hello,

I'm trying to take a column containing past dates (in the format:
MM/DD/YYYY); compare it to a CONSTANT, more current date (e.g. 04/01/2007);
calculate the difference in the number of days (my first choice) or months
(second choice); then populate that result in a corresponding column in that
same Excel sheet.

Your help is always appreciated and thanks in advance!

Chris