LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sue Sue is offline
external usenet poster
 
Posts: 285
Default Macro or other code for deteming Months, Years, Quarter based on d

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summation of months or years Sandeep Nair Excel Worksheet Functions 7 November 4th 08 06:22 PM
Code for auto filling in Excel based on number of months, & start date Diane Sulton Excel Programming 1 March 1st 06 01:15 AM
Fill Sum of months by quarter vmagal1 Excel Worksheet Functions 2 January 10th 06 06:46 PM
converting months to years and months??? Marty Excel Discussion (Misc queries) 1 February 18th 05 02:38 AM
years and months [email protected] Excel Worksheet Functions 5 January 8th 05 02:53 PM


All times are GMT +1. The time now is 11:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"