| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date calculation
I have a column of dates in Column A that generate with a formula like so:
A1 "=O18" (This is currently a date that is inputted by the user. a2 "=b1+1" Column b is like: b1 "=a1+13" b2 "=a2+13" (Quotes are used here to indicate the formula I am using in the cells) These formulas go down about 57 cells. I would like to automate this so that when the last cell is equal to (Or greater than) today, cell A1 will automatically change to the date in the last cell. Any help in how to do this would be greatly appreciated! Thanks, Tim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A specific date used for calculation of a new date | Excel Discussion (Misc queries) | |||
| Date Calculation (from entered date / 1yr later in next field) | Excel Worksheet Functions | |||
| End Date Calculation (adding a start date duration) | Excel Discussion (Misc queries) | |||
| Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
| Coding to show first _weekday_ prior to a date, when date calculation happens to fall on weekend? | Excel Programming | |||
Threaded Mode
