| 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? |
| 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 | |||
Threaded Mode
