First part is simple: the formula in E4 should be =D4+28 (adding 28 days to the date).
Sending an automatic e-mail needs VBA-code, and moreover a way to send it only once, not tomorrow and the day after again. That's certainly not standard.
For an example of conditional formatting, see http://www.mrexcel.com/tip054.shtml. The Excel help, or other hits from http://www.google.com/search?q=excel+%22conditional+formatting%22 will surely be informative also.
Hope this helps.
Kees
Can anyone tell me how to do this please?
I want a formula to make a cell automatically produce a date that is 28 days later than the date entered into the adjacent cell. Then, if the date is today or has already passed, the date should turn red. If it is possible I'd like it to generate an automatic e-mail to the person whose name appears in another adjacent cell but that isn't essential.
So, if 01/01/04 is in D4, 29/01/04 should be generated in E4 (I'm in Europe so use dd/mm/yy) and if it is now 30/01/04 then the date 29/01/04 should turn red.
Any clever people out there willing to help? TVM

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic