| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Round up month
How do I calculate the "the 1st day of the month following 60 (or any number of days) days" -- Edfermo ------------------------------------------------------------------------ Edfermo's Profile: http://www.excelforum.com/member.php...o&userid=29231 View this thread: http://www.excelforum.com/showthread...hreadid=489547 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Round up month
If you ALWAYS need to go to the first of the following month,
=date(year(today()+60),month(today()+60)+1,1). If that 60-day wait winds up on the 1st and you then DON'T need to wait for the first of the following month, make it conditional: =if(day(today()+60)=1,today()+60,date(year(today() +60),month(today()+60)+1,1)). "Edfermo" wrote: How do I calculate the "the 1st day of the month following 60 (or any number of days) days" -- Edfermo ------------------------------------------------------------------------ Edfermo's Profile: http://www.excelforum.com/member.php...o&userid=29231 View this thread: http://www.excelforum.com/showthread...hreadid=489547 |
|
#3
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 | |||
Linear Mode
