| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Months between two dates
I need to find out if the elapsed time between two dates (TRANS Date, Issue
Date) is = to or < 12 months. If it is need it to say "1st YR", and if not "Renewal". |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Months between two dates
Dear Jason
Use DATEDIF() with an IF() With Start Date in A1 and end date in B1 try =IF(DATEDIF(A1,B1,"m")12,"Renewal","1st YR") OR =IF(DATEDIF(TRANS Date, Issue Date,"m")12,"Renewal","1st YR") If this post helps click Yes --------------- Jacob Skaria "Jason K" wrote: I need to find out if the elapsed time between two dates (TRANS Date, Issue Date) is = to or < 12 months. If it is need it to say "1st YR", and if not "Renewal". |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Months between two dates
Thanks alot, it worked, and also brought to my attention some other stuff
"Jacob Skaria" wrote: Dear Jason Use DATEDIF() with an IF() With Start Date in A1 and end date in B1 try =IF(DATEDIF(A1,B1,"m")12,"Renewal","1st YR") OR =IF(DATEDIF(TRANS Date, Issue Date,"m")12,"Renewal","1st YR") If this post helps click Yes --------------- Jacob Skaria "Jason K" wrote: I need to find out if the elapsed time between two dates (TRANS Date, Issue Date) is = to or < 12 months. If it is need it to say "1st YR", and if not "Renewal". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to transform the dates to months | Excel Worksheet Functions | |||
| Display Months by looking at the dates | Excel Worksheet Functions | |||
| Adding months to dates should account for 28-30-31 day months | Excel Worksheet Functions | |||
| months between 2 dates!!! | Excel Discussion (Misc queries) | |||
| Need More Help on Dates to Months | Excel Worksheet Functions | |||
![Jason K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
