VansAirForceForums  
Home > VansAirForceForums

- POSTING RULES
- Donate yearly (please).
- Advertise in here!

- Today's Posts | Insert Pics


Go Back   VAF Forums > Main > RV Ongoing Maintenance Issues
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Display Modes
  #11  
Old 05-09-2018, 12:44 PM
az_gila's Avatar
az_gila az_gila is offline
 
Join Date: Jan 2005
Location: 57AZ - NW Tucson area
Posts: 10,011
Smile

Quote:
Originally Posted by snopercod View Post
It's already in Excel, but I'm unfamiliar with those date functions. I'll have to play around with that.
It's not too bad.

Each item gets a line. One column can give status on the day you open the file -

=IF($H$1>F6, "Due!!",IF($H$1+25>F6,"soon","OK"))

Do some conditional formatting to color code the status.

$H$1 is a fixed cell with todays date - =TODAY()
__________________
Gil Alexander
EAA Technical Counselor, Airframe Mechanic
Half completed RV-10 QB purchased
RV-6A N61GX - finally flying
Grumman Tiger N12GA - flying
La Cholla Airpark (57AZ) Tucson AZ
Reply With Quote
  #12  
Old 05-09-2018, 12:57 PM
snopercod's Avatar
snopercod snopercod is offline
 
Join Date: Aug 2016
Location: Asheville, NC
Posts: 2,104
Default

Thanks, Gill. That makes it easy!
__________________
(2020 dues paid)
Reply With Quote
  #13  
Old 05-09-2018, 02:08 PM
Kuhtenia Kuhtenia is offline
 
Join Date: Jan 2018
Location: Galena, Ohio
Posts: 28
Default

24-month flight review for the list?
__________________
2020 dues paid
RV-6A
Reply With Quote
  #14  
Old 05-09-2018, 04:40 PM
snopercod's Avatar
snopercod snopercod is offline
 
Join Date: Aug 2016
Location: Asheville, NC
Posts: 2,104
Default

Quote:
Originally Posted by Kuhtenia View Post
24-month flight review for the list?
Dang...I forgot that one, too. Thanks!
__________________
(2020 dues paid)
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -6. The time now is 02:24 AM.


The VAFForums come to you courtesy Delta Romeo, LLC. By viewing and participating in them you agree to build your plane using standardized methods and practices and to fly it safely and in accordance with the laws governing the country you are located in.