Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

help newbie please this is driving me nuts

  Asked By: Gail    Date: Jan 01    Category: MS Office    Views: 2439
  

I'm creating a sheet which calculates re-rostered rest days in
column a the user types a date the day was earned (Date Worked) , column
b auto calculates a date 3 months in advance of the user date Column c
automatically calculates the months passed between the two dates (months
past), in column d the user types in the number of days owed (days
Owed), in column e the user would type in the date the day was taken
(date taken), column f shows if the day earned is less than 3 months old
and column G if the day earned is more than 3 months old.

For example



Column a column b months days Date
<3months >3months

Past
owed Taken



01/09/2005

01/12/2005

4

1



0

1





My question is when the user enters the date taken date how do I cancel
the numbers in the days owed cell and either the <3months cell or the
>3months cell using vba.



I'd be grateful for any help you might be able to offer.

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on help newbie please this is driving me nuts Or get search suggestion and latest updates.




Tagged: