Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formula
"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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formula
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Trending Formula Results by Date | Excel Worksheet Functions | |||
Year-to-date year to date formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions |