| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding Date to Next Half Year
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If a date range contains a leap year (date) | Excel Worksheet Functions | |||
| print half of rows on left and other half on right | Excel Discussion (Misc queries) | |||
| Help w/formula to add 1 year to cell (date done) date due? | Excel Worksheet Functions | |||
| Year-to-date year to date formula | Excel Worksheet Functions | |||
| Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
Threaded Mode
