| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Calculation (from entered date / 1yr later in next field)
In Excel, I want to be able to enter a date in one field and have a date that
is 1 year later in the field next to it; what formula may I use to achieve this? Also, if the resulting date is past, how do I make the date turn red? And, if the first date is 8/30/2008, how do I make it that it turns Green when we are three months before this date? -- AjaminB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Entered +7, unless another field is greater than 0 | Excel Worksheet Functions | |||
| New date based on one date field minus minutes in another field | Excel Discussion (Misc queries) | |||
| Dates - Need to display date one month prior to user-entered date | Excel Worksheet Functions | |||
| Date subtraction -How to not show negative when 2nd date not entered | New Users to Excel | |||
| #NUM! in Date field calculation | Excel Worksheet Functions | |||
Threaded Mode
