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