| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Warning
My spreadsheet has dates that employees were certified on. In one cell I
have that such date. I would like to have the adjacent cell add 6 months and turn red if it goes over. Any advise??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Warning
Add 6 months:
A2: =DATE(YEAR(A1),MONTH(A1)+6,DAY(A1)) To turn red, use Format/Conditional Formatting... CF1: Formula is =TODAY()A2 Format1: <patterns/<red In article , smack wrote: My spreadsheet has dates that employees were certified on. In one cell I have that such date. I would like to have the adjacent cell add 6 months and turn red if it goes over. Any advise??? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Warning
That worked!! Your are great!!!
Thank you again, Sue "JE McGimpsey" wrote: Add 6 months: A2: =DATE(YEAR(A1),MONTH(A1)+6,DAY(A1)) To turn red, use Format/Conditional Formatting... CF1: Formula is =TODAY()A2 Format1: <patterns/<red In article , smack wrote: My spreadsheet has dates that employees were certified on. In one cell I have that such date. I would like to have the adjacent cell add 6 months and turn red if it goes over. Any advise??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| Date format issue | New Users to Excel | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Another Date issue. | Excel Worksheet Functions | |||
| Warning message base on date | Excel Worksheet Functions | |||
Linear Mode
