complex date function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
=DATEDIF(A1,DATE(YEAR(TODAY())+(MONTH(TODAY())>8),9,1),"M")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Generating date from day, month year 4
Date Formula 13
formula to subtract 60 days from a date (05/25/2010) 2003excel 3
Conditional Formatting with Dates (Revised) 5
Date lists 3
Counting cells in a selectable date range 0
Comparing dates 3
countifs Function not giving desired result with date criteria 2

Back
Top