Home |
Search |
Today's Posts |
#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 ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NEED HELP! Cannot figure out complex function | Excel Worksheet Functions | |||
Complex if and mid function. | Excel Worksheet Functions | |||
Excel date function | Excel Worksheet Functions | |||
Is there a function to show future date | Excel Worksheet Functions | |||
Date Function | Excel Worksheet Functions |