View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default How to Calc a full month

Hi,

You could try

=DATEDIF(B1,C1+1,"m")

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Christina" wrote:

Is it possible to set the last day of the month to calculate as a full month?

Example: Calculating 11/1/08 to 1/31/09 and using the DATEDIF function. I
need it to say 3 months, not 2.

Is this possible??