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!!

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!!

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!!

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!!