| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Next January 1 or July 1
Hi, I was looking for a cell formula that returns the next January 1 or July 1 after a given date.
Examples: 3/8/2013 would return 7/1/2013 or 8/21/2014 would return 1/1/2015 Here is a formula for returning the first day of the next quarter (provided by "Bernd P") - but I wasn't able to tweak it to return the next Jan. 1 or July 1: =DATE(YEAR(A1),1+FLOOR(MONTH(A1)+2,3),1) Thanks. Last edited by ElizabethWells : September 24th 14 at 01:36 AM Reason: I changed the title and added a similar function to the post. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| January 08 is abbrecviated to 8-Jan. Help! | Excel Discussion (Misc queries) | |||
| Return day of week for 1 January | Excel Worksheet Functions | |||
| Return the day of week for 1 January | About this forum | |||
| January 2006 | Excel Discussion (Misc queries) | |||
| error with smproduct for January | Excel Discussion (Misc queries) | |||
Threaded Mode
