Date Formula

[wdemery]

I have a company formatted Expense sheet that is required for all business expenses. Row A10, Then columns BCDEFGH, IJKLMNO, PQRSTUV, WXYZ AA AB AC, and AD AE AF AG AG AI AJ are merged to make a five day spread. I am presently entering each date seperately. I would like to write a formula for each day so that when I enter the first date, the other four dates are automatically incremented and entered. Is this possible?

[Rich]

"wdemery" wrote:

>
> I have a company formatted Expense sheet that is required for all
> business expenses. Row A10, Then columns BCDEFGH, IJKLMNO, PQRSTUV,
> WXYZ AA AB AC, and AD AE AF AG AG AI AJ are merged to make a five day
> spread. I am presently entering each date seperately. I would like to
> write a formula for each day so that when I enter the first date, the
> other four dates are automatically incremented and entered. Is this
> possible?
>
>
> --
> wdemery
> ------------------------------------------------------------------------
> wdemery's Profile: http://www.excelforum.com/member.php...o&userid=37713
> View this thread: http://www.excelforum.com/showthread...hreadid=573010
>
>

[Rich]

if first date is in a10
in a11 put =a10+1


"wdemery" wrote:

>
> I have a company formatted Expense sheet that is required for all
> business expenses. Row A10, Then columns BCDEFGH, IJKLMNO, PQRSTUV,
> WXYZ AA AB AC, and AD AE AF AG AG AI AJ are merged to make a five day
> spread. I am presently entering each date seperately. I would like to
> write a formula for each day so that when I enter the first date, the
> other four dates are automatically incremented and entered. Is this
> possible?
>
>
> --
> wdemery
> ------------------------------------------------------------------------
> wdemery's Profile: http://www.excelforum.com/member.php...o&userid=37713
> View this thread: http://www.excelforum.com/showthread...hreadid=573010
>
>