The word "code" is usually used with VBA or other programming languages. You can simply add 1 (or 7) to a cell to increase the date.=C1 1This site might help...How to set up function for update the dates, times in Excel document?Value = arr_date If ((arr_date - Date) 12 Then Msg Box "Invalid date, make sure format is (dd/mm/yyyy)", vb Critical txt A_Date CR.Set Focus Exit Sub End If d Date = Date Serial(Year(Date), Month(Date), Day(Date)) txt A_Date CR.If you add a row or two of data to your spreadsheet, you can easily update the Excel chart pertaining to that data by changing the chart's data range.
Enable Events = False For Each Rng In Work Rng If Not VBA.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site.
If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
i dont understand what you mean, can you please explain with a lot more detail.
Please remember we cannot see your workbook so have no idea how it looks or what the fields are.