| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Calc a full month
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?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't get NETWORKDAYS to calc elapsed banking days in a month | Excel Worksheet Functions | |||
| Autofilter by month & year when I have a column full of dates ?? | Excel Discussion (Misc queries) | |||
| Calc Prorated Cost based on Specific Days in a Given Month & Year Range (Revisited..) | Excel Discussion (Misc queries) | |||
| how to calculate a month without the full date? | New Users to Excel | |||
| I'm looking for a formula to calc # of days left in a month | Excel Worksheet Functions | |||
Linear Mode
