Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Date Formula
Hi there, Hopefully someone can help me, I have dates along a row, say from column A out to column Z. The dates either stay the same or increase as you move from column to column. i.e A1= 25 May, B1= 25 May, C1= 27 May, D1= 29 May I am looking to place a formula, two rows below, which looks at the formula above and adds 13 days on to it, or 15 days or 17 days or 21 days, 23 days, 25 days. Only if the dates above are the same, and 13 days if the Date is different. i.e H1= 1 June, I2= 1 June, J1= 1 June, K1 = 1 June, L1 = 1 June, M1 = 1 June H3= 14 June, I3= 15 June, J3= 17 June and so on, the problem I have is that the cell before has always got to have a lesser date than the cell to the right of it. Sometimes this doesn't happen as the cell in N1= 5 June, then N3= 18 June, which is less than M3= 30 June Is there any way I can get the formula on Row3, to say if the cell to the left is greater than the date in the cell to the left (based on the criteria above then add two days on to the cell on the right so that its always greater than the cell to left of it? hope this makes sense BigH -- BigH ------------------------------------------------------------------------ BigH's Profile: http://www.excelforum.com/member.php...o&userid=34410 View this thread: http://www.excelforum.com/showthread...hreadid=541869 |
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 |