#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 112
Default Recurring Date

Hi,
I am new to excel formulas and would like to know if it is possible to have
a recurring date. For example:
Column E = Start Date
Column F = Status
When Column F = "Status Complete" then column E start date changes to
current date + 7.

Thanks,
Mickey
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default Recurring Date

You will need to use the Worksheet Change event to change the date in the
same cell to a different value. Right click on the sheet tabView code and
then paste the below code...Try and feedback..

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 6 Then
If Trim(Cells(Target.Row, 6)) = "Status Complete" _
Then Cells(Target.Row, 5) = Date + 7
End If
End Sub

'Set the Security level to low/medium in (Tools|Macro|Security)


If this post helps click Yes
---------------
Jacob Skaria


"Mickey" wrote:

Hi,
I am new to excel formulas and would like to know if it is possible to have
a recurring date. For example:
Column E = Start Date
Column F = Status
When Column F = "Status Complete" then column E start date changes to
current date + 7.

Thanks,
Mickey

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 112
Default Recurring Date

Thanks Jacob,
It worked perfectly by changing "Date + 7" to "(Date) + 7".

Thanks again,
Mickey

"Jacob Skaria" wrote:

You will need to use the Worksheet Change event to change the date in the
same cell to a different value. Right click on the sheet tabView code and
then paste the below code...Try and feedback..

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 6 Then
If Trim(Cells(Target.Row, 6)) = "Status Complete" _
Then Cells(Target.Row, 5) = Date + 7
End If
End Sub

'Set the Security level to low/medium in (Tools|Macro|Security)


If this post helps click Yes
---------------
Jacob Skaria


"Mickey" wrote:

Hi,
I am new to excel formulas and would like to know if it is possible to have
a recurring date. For example:
Column E = Start Date
Column F = Status
When Column F = "Status Complete" then column E start date changes to
current date + 7.

Thanks,
Mickey

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Recurring Numbers albertmb Excel Discussion (Misc queries) 8 April 20th 08 08:34 PM
Recurring pattern LaDdIe Excel Worksheet Functions 2 March 9th 07 10:25 PM
Recurring annual events using a specific date as a trigger date Bamboozled Excel Worksheet Functions 1 June 6th 05 01:44 PM
Calculating recurring date in following month, calculating # days in that period Walterius Excel Worksheet Functions 6 June 4th 05 11:21 PM
recurring dates sonoundio Excel Discussion (Misc queries) 1 May 24th 05 01:53 AM


All times are GMT +1. The time now is 09:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"