Jumpt to Next June

Microsoft Excel 2003 (full product)
April 10, 2010 at 12:35:07
Specs: Windows XP
Is there a formula that would move a date in B3 to the next June 30th?

See More: Jumpt to Next June

Report •

#1
April 10, 2010 at 13:10:52
Not sure what your asking for, your information is a bit thin,
but if you have a date in B3 then putting this formula in B4 will always give you June 30th.

=EOMONTH(B3,6-MONTH(B3))

MIKE

http://www.skeptic.com/


Report •

#2
April 10, 2010 at 13:15:51
Sorry so thin, Mike! I have a date and need to advance it to the next June 30th.

Report •

#3
April 10, 2010 at 13:18:56
I'm getting #Name? with this formula.

Report •

Related Solutions

#4
April 10, 2010 at 13:23:10
Oh, just read how to load Analysis ToolPak. Hmmm. I need to email this spreadsheet to other users with various versions/OS.

Report •

#5
April 10, 2010 at 13:28:37
I need to email this spreadsheet to other users with various versions/OS.

Just add a note, telling them to make sure they have the Analysis ToolPak add-in checked.

I'm pretty sure it comes with all versions.

MIKE

http://www.skeptic.com/


Report •

#6
April 10, 2010 at 13:51:43
Hi,

If you can't use EOMONTH() as suggested by Mike, try this formula

=IF(B3<DATE(YEAR(B3),6,30),DATE(YEAR(B3),6,30),DATE(YEAR(B3)+1,6,30))

Up to 29th June, this returns 30th June in the same year, and from 30th June on it returns 30th June of the next year.

Regards


Report •

#7
April 10, 2010 at 14:06:13
I'M DANCING! THANKS SO MUCH!

Report •

Ask Question