If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
complex date function
OK here's what I need:
A user enters a date in A1, A2 should count number of full months between the date entered and the next September 1st. So if they enter 6/28/05 in A1, A2 should read with the number 2 (counting the months of July and August). If they enter 11/21/04 in A1, it should calculate to 9 and so on. If they enter a date in A1 that is the first of a month, then it should count that month as well. So if they enter 5/1/05 in A1, A2 should read 4. Of course this is possible but I can't seem to figure it out. Any suggestions? |
#2
|
|||
|
|||
=DATEDIF(A1,DATE(YEAR(TODAY())+(MONTH(TODAY())8), 9,1),"M")
-- HTH RP (remove nothere from the email address if mailing direct) "tjb" wrote in message news OK here's what I need: A user enters a date in A1, A2 should count number of full months between the date entered and the next September 1st. So if they enter 6/28/05 in A1, A2 should read with the number 2 (counting the months of July and August). If they enter 11/21/04 in A1, it should calculate to 9 and so on. If they enter a date in A1 that is the first of a month, then it should count that month as well. So if they enter 5/1/05 in A1, A2 should read 4. Of course this is possible but I can't seem to figure it out. Any suggestions? |
#3
|
|||
|
|||
=DATEDIF(A1,DATE(2005,9,1),"m")
"tjb" wrote: OK here's what I need: A user enters a date in A1, A2 should count number of full months between the date entered and the next September 1st. So if they enter 6/28/05 in A1, A2 should read with the number 2 (counting the months of July and August). If they enter 11/21/04 in A1, it should calculate to 9 and so on. If they enter a date in A1 that is the first of a month, then it should count that month as well. So if they enter 5/1/05 in A1, A2 should read 4. Of course this is possible but I can't seem to figure it out. Any suggestions? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
NETWORKDAYS - Multiple Date Selection | Annabelle | General Discussion | 3 | October 4th, 2005 07:04 PM |
Copy Cat Ain't Working | shep | Setting Up & Running Reports | 15 | September 12th, 2005 05:14 PM |
Attaching Code | DS | General Discussion | 2 | August 22nd, 2005 11:21 PM |
date time =now() function | Brenda | Worksheet Functions | 7 | May 10th, 2004 12:18 AM |
Excel date function | Sheela | Worksheet Functions | 2 | October 28th, 2003 10:12 AM |