Hi Tricia,
You would need a macro.
If you say you have a cell, you are going to get a specific
solution that only works for one cell on the active worksheet.
Don't you have to enter something manually anyway?
You can use Ctrl+; (semicolon) to get a constant for the
current date and use a formula in A2 for today+30
=A1+30
You can use an Event Macro to check if a cell on the same
row as something you update is empty and if it is to
fill today's date + 30.
For a quick example suppose you want
Today's date as a constant in Column A, date + 30
in column B whenever a new entry is made in Column C.
The actual way new entry would be determined (as opposed
to an update to cell in column C) would be if Column A in the row is still empty.
the following is modified from #autodate in
Event Macros, Worksheet Events and Workbook Events
http://www.mvps.org/dmcritchie/excel/event.htm#autodate
If this is the type of thing you want to do, please look over the
entire page.
Private Sub Worksheet_Change(ByVal Target As Range)
'to install -- right-click on the sheettab of the sheet to
' be used in and choose 'view code'. Paste this Worksheet
' event macro into the module.
If Target.Column <> 3 Then Exit Sub
If Target.Row = 1 Then Exit Sub
If IsEmpty(Target.Offset(0, -2)) _
and IsEmpty(target.offset(0,-1)) Then
Target.Offset(0, -2) = Date
Target.offset(0, -1) = Date + 30
End If
End Sub
