| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating months between dates
'Fred Smith[_4_ Wrote: ;3455255']How about: =datedif(a1,a2,"m")+(a2=eomonth(a2,0)) Regards, Fred "wendy" wrote in message ...- I have looked through some older posts and thought I had found the answer to my problem I'm nearly there but not quite! The start date identifies the start month. It doesn't matter what date in the month it is. The end date month only counts if the end date is the last day of the month i.e. 10 May to 29 June would only count as 1 month for May. 10 May to 30 June would count as 2 months because it includes the last day of the month. can anyone help I am using datedif to work out the months but I only want it to count the end date month if it is the last day of the month. The list contains various end dates like the example above. Thanks in advance for any help on this x -- wendy - thankyou for your help x -- wendy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help Calculating Partial Months between 2 dates. | Excel Worksheet Functions | |||
| Calculating Years and Months Between Dates | Excel Discussion (Misc queries) | |||
| Calculating months with half months. | Excel Discussion (Misc queries) | |||
| Calculating an Activities During Periods Of Natural Months and/or Dates | Excel Worksheet Functions | |||
| Calculating Dates in Terms of Months | Excel Worksheet Functions | |||
Hybrid Mode
