| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Round up month
On Wed, 30 Nov 2005 13:30:15 -0600, Edfermo
wrote: How do I calculate the "the 1st day of the month following 60 (or any number of days) days" If I understand you correctly, you wish to add 60 to some date, and then find the first of the month of that new date. =A1+61-DAY(A1+60) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Working days left in the month compared to previous months | Excel Worksheet Functions | |||
| Referencing data in different worksheet based on month name | Excel Worksheet Functions | |||
| Round date to first of month | Excel Discussion (Misc queries) | |||
| Round whole numbers up and down | Excel Discussion (Misc queries) | |||
| Month Year Date Format | Excel Worksheet Functions | |||
Hybrid Mode
