I meant if you use now() to generate the first date, then copy and paste it into the first cell. I should have said use paste / special / dates, not paste / special / numbers. It may not make any difference if the cell is already formatted for dates.
tc
Chris Aitken wrote:
Anthony Chilco wrote:
If you do that, paste 'dates', not numbers.
Why is that? Our top cell is the first date. Our second cell is the formula you gave us. The third cell and beyond are just copies of the formula (in the second cell). It's working great...
Chris
tc
Chris Aitken wrote:
Today only (or next week), you could enter =now() in A1, copy, then paste numbers only into the same cell. Then do the fill down with the formula above.
I'll keep this idea on file - thanks.
<snip>
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
