| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advancing date to the first of next month?
I have a "start date" of 12/17/06 & I need a formula that will advance first
billing date to 01/10/05. I'm already using "=date(year(a1),month(a1)+1,10)". When going from December to January, I'm getting #NUM! Thanks!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Advancing date to the first of next month?
Statesman --
Howze about: =DATE(YEAR(EDATE(A1,1)),MONTH(EDATE(A1,1)),10) Tried it, and it seemed to work for months of various lengths and across the end of the year. HTH "Statesman" wrote: I have a "start date" of 12/17/06 & I need a formula that will advance first billing date to 01/10/05. I'm already using "=date(year(a1),month(a1)+1,10)". When going from December to January, I'm getting #NUM! Thanks!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Advancing date to the first of next month?
Your formula works for me. However, another approach is to ensure that the
Analysis Toolpak add-in is installed (Tools-Addins & make sure Analysis Toolpak is checked) and use this formula =eomonth(a1,0)+10 "Statesman" wrote: I have a "start date" of 12/17/06 & I need a formula that will advance first billing date to 01/10/05. I'm already using "=date(year(a1),month(a1)+1,10)". When going from December to January, I'm getting #NUM! Thanks!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Advancing date to the first of next month?
Toolsoptionstransition and de-select transition formula evaluation
-- Regards, Peo Sjoblom "Statesman" wrote in message ... I have a "start date" of 12/17/06 & I need a formula that will advance first billing date to 01/10/05. I'm already using "=date(year(a1),month(a1)+1,10)". When going from December to January, I'm getting #NUM! Thanks!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
| how can I stop Excel Advancing the year by 1 when I enter a date? | Excel Discussion (Misc queries) | |||
| =VLOOKUP(1,Nationality!B5:B29,IF(MONTH(date)6,MONTH(date)-6, MON | Excel Worksheet Functions | |||
| Month to date sales - reset in new month??? | Excel Worksheet Functions | |||
Linear Mode
