Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 10-16-2018, 02:43 AM
ArviLaanemets ArviLaanemets is offline Creating a formula that will determine if a code type occurs within 90 days of anotherspecific type Windows 8 Creating a formula that will determine if a code type occurs within 90 days of anotherspecific type Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Don't understand your table logic! You table will be have some logic when:
1. You need a formula in column 'WITHIN 90' returning "Y" when something described in table row is paid within 90 days from 'BEGDATE', "N" when it was paid later than 90 days from 'BEGDATE' or is not paid and currently more than 90 days is passed from 'BEGDATE', and returning an empty string when it is not paid and currently less than 90 days is passed from 'BEGDATE'. When this is the case, you need an additional field in your table (e.g. 'PayDate'), where date the payment was finished will be stored;
2. You enter into column 'WITHIN 90' manually "Y" or "N" when the payment is made. When this is the case, you need the information, is the entry within 90 days or not, to use right character. One possibility is to have an additional column with formula which displays "N" whenever the entry is out of 90 day limit and payment is not made yet (there is no entry in column 'WITHIN 90'). Or you use conditional formatting in your table to color entries out of 90 day limit and payment not made in one color, entries paid later than 90 days in another color, and entries paid earlier in 3rd color (no need for additional column then).

The formula for additional column in 2. will be something like
Code:
=AND(TODAY()-$D2>90;$C2="")
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I type this exactly? Akki Word 4 01-26-2016 12:22 AM
What type of box do I have? teholder Word 4 12-11-2015 09:50 PM
Type in box during presentation JoelW2013 PowerPoint 1 12-10-2013 06:43 AM
Type once - enter twice garymeagher Word 1 12-10-2010 06:07 AM
Word won't let me type t, c, h, v laxation Word 0 04-22-2010 12:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:37 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft