(Msg. 1) Posted: Fri Oct 30, 2009 1:11 pm
Post subject: Tracking due dates Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
Hi - I've got this tracking sheet in which i track training dates and
recurrent training due dates. For ex. an individual is required to take a
refresher course every 3 yrs. What formula can i use for the cell to
recognize that the training is over due and change color?
(Msg. 2) Posted: Fri Oct 30, 2009 8:05 pm
Post subject: Re: Tracking due dates [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"Bourgge" <Bourgge.TakeThisOut@discussions.microsoft.com> wrote in message
news:AB0A8FB9-ADCF-4F48-9E78-FEA8ED59B4FD@microsoft.com...
> Hi - I've got this tracking sheet in which i track training dates and
> recurrent training due dates. For ex. an individual is required to take a
> refresher course every 3 yrs. What formula can i use for the cell to
> recognize that the training is over due and change color?
>
> Thanks,
>
>
(Msg. 3) Posted: Sat Oct 31, 2009 6:05 am
Post subject: Re: Tracking due dates [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Perhaps Ashish intended to say =datedif(B3,today(),"y")>3 ?
--
David Biddulph
Ashish Mathur wrote:
> Hi,
>
> In formula is of conditional formatting, use
>
> =datedif(today()-B3,"y")>3
>
> B3 holds the date of previous training
>
>
> "Bourgge" <Bourgge.RemoveThis@discussions.microsoft.com> wrote in message
> news:AB0A8FB9-ADCF-4F48-9E78-FEA8ED59B4FD@microsoft.com...
>> Hi - I've got this tracking sheet in which i track training dates and
>> recurrent training due dates. For ex. an individual is required to
>> take a refresher course every 3 yrs. What formula can i use for the
>> cell to recognize that the training is over due and change color?
>>
>> Thanks,
(Msg. 4) Posted: Sat Oct 31, 2009 8:05 am
Post subject: Re: Tracking due dates [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"David Biddulph" <groups [at] biddulph.org.uk> wrote in message
news:l_ydnZ80ZaW_YHbXnZ2dnUVZ7s6dnZ2d@bt.com...
> Perhaps Ashish intended to say =datedif(B3,today(),"y")>3 ?
> --
> David Biddulph
>
> Ashish Mathur wrote:
>> Hi,
>>
>> In formula is of conditional formatting, use
>>
>> =datedif(today()-B3,"y")>3
>>
>> B3 holds the date of previous training
>>
>>
>> "Bourgge" <Bourgge.RemoveThis@discussions.microsoft.com> wrote in message
>> news:AB0A8FB9-ADCF-4F48-9E78-FEA8ED59B4FD@microsoft.com...
>>> Hi - I've got this tracking sheet in which i track training dates and
>>> recurrent training due dates. For ex. an individual is required to
>>> take a refresher course every 3 yrs. What formula can i use for the
>>> cell to recognize that the training is over due and change color?
>>>
>>> Thanks,
>
>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office