| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate number of months based on one date
In excel, how do you calculate the number of months that have passed between
the first of the year and the one date that is available on the worksheet? In other words, if I enter today's date in a field on my worksheet, I want a formula to automatically display the number of months that have passed since the first of this year and the date I entered. Everything I see is based on the number of months between two dates. I only have one. I appreciate your help! Jason |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate number of months based on one date
Hi,
With your date in a1 try this =DATEDIF(DATE(YEAR(A1),1,1),A1,"m") datedif isn't documented in Excel, for help look here http://www.cpearson.com/excel/datedif.htm Mike "JK" wrote: In excel, how do you calculate the number of months that have passed between the first of the year and the one date that is available on the worksheet? In other words, if I enter today's date in a field on my worksheet, I want a formula to automatically display the number of months that have passed since the first of this year and the date I entered. Everything I see is based on the number of months between two dates. I only have one. I appreciate your help! Jason |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate number of months | Excel Discussion (Misc queries) | |||
| Calculate number of months between dates | Excel Worksheet Functions | |||
| Calculate a 30-day moving average based on the last x number of entries and date | Excel Worksheet Functions | |||
| Calculate number of years and months employed using hire date and. | Excel Worksheet Functions | |||
| How to calculate "number of months" between two given date? | Excel Worksheet Functions | |||
Linear Mode
