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

Sorry so thin, Mike! I have a date and need to advance it to the next June 30th.

I'm getting #Name? with this formula.

Oh, just read how to load Analysis ToolPak. Hmmm. I need to email this spreadsheet to other users with various versions/OS.

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

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

I'M DANCING! THANKS SO MUCH!

Ask Your Question

Weekly Poll