Rounding Date to Next Half Year

F

frrrrrr

I'm trying to compose a formula that will give me the date of the nearest
half year. Meaning, if I open the spreadsheet today I'd like to get
1/1/2009. If I open the spreadsheet sometime in January I'd like to get
7/1/2010.

I'd appreciate any help!
 
R

Ron Rosenfeld

I'm trying to compose a formula that will give me the date of the nearest
half year. Meaning, if I open the spreadsheet today I'd like to get
1/1/2009. If I open the spreadsheet sometime in January I'd like to get
7/1/2010.
Click to expand...

Assuming by January you mean this next January (January 2009), how does 1 July
2010 compute to be the "nearest" half year.
--ron
 
P

Peo Sjoblom

That is not nearest, your are rounding up. Also in January next year why
would you return July of 2010. If you meant July 2009 then this might work

=DATE(YEAR(TODAY()),CEILING(MONTH(TODAY()),6)+1,1)

--


Regards,


Peo Sjoblom
 
Top