Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a very specific problem related to dates. In order to do what I want
each cell is requiring different formulas. If there is a way to do what I need to using a macro or VBA Code that would make things much easier. I have a spreadsheet with 13 columns the last three (K, L and M) being Months, Years and Quarter I have a series of dates that I have to work with that look like this in columns G, H, I and J StartDate Adj_Start_Date Current_Date Term_Date 5/31/2000 5/31/2000 5/31/2000 4/1/2007 11/10/2004 5/31/2000 4/1/2007 1/31/2006 5/31/2000 4/1/2007 3/3/2007 5/31/2000 4/1/2007 5/29/2000 9/18/2004 8/31/2004 5/29/2000 9/18/2004 5/31/2000 5/31/2000 5/31/2000 1/1/2003 5/31/2001 5/31/2000 1/12/2006 1/3/2000 5/31/2000 1/12/2006 8/1/2003 5/31/2000 1/12/2006 10/1/2004 5/31/2000 1/12/2006 5/31/2000 5/31/2000 5/31/2000 5/31/2000 5/31/2000 5/31/2000 5/29/2000 5/29/2000 6/30/2007 6/30/2007 What I would like to do is calculate the months, years and quarter for each row in order to determine how long each person has been on the account. Forinstance if both the start date and adj_start_Date are populated (and are the same) and not other date is populated I would calculate the months, years and quarter based on the start date and today's date. As you can see I have term_dates that do not match the adj_start_date. In this case I would have to calculate the months, years and quarter based on the TermDate and the StartDate if no current date is populated. If the current date is populated the dates calcutions would be between the adj_start date and the currentdate. I'm having a problem performing these using functions. If there is code that will help I'd be appreciative. Thank you in advance for your help. Regards, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Summation of months or years | Excel Worksheet Functions | |||
Code for auto filling in Excel based on number of months, & start date | Excel Programming | |||
Fill Sum of months by quarter | Excel Worksheet Functions | |||
converting months to years and months??? | Excel Discussion (Misc queries) | |||
years and months | Excel Worksheet Functions |