Date: Auto text entry based on aging

's Computer Specifications

L17 contains the Status Date (mm/dd/yyyy). If the date in L17 is seven days
older than the date I've manually entered in B3, then M17 should read "Update
Needed"; if within seven days from B3, it should read, "Current".

I am unable to get my formulas to work. Are there any suggestions?

's Computer Specifications

Enter the following formula in cell M17
=IF(L17-B3>=7,"Update Needed","Current")

"Annabelle" <(E-Mail Removed)> wrote in message
news:B1683322-F67C-42CE-9CAD-(E-Mail Removed)...
> L17 contains the Status Date (mm/dd/yyyy). If the date in L17 is seven
> days
> older than the date I've manually entered in B3, then M17 should read
> "Update
> Needed"; if within seven days from B3, it should read, "Current".
>
> I am unable to get my formulas to work. Are there any suggestions?

's Computer Specifications

Sorry I got it the wrong way round, it should be as this

=IF(B3-L17>=7,"Update Needed","Current")

"Howard31" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Enter the following formula in cell M17
> =IF(L17-B3>=7,"Update Needed","Current")
>
> "Annabelle" <(E-Mail Removed)> wrote in message
> news:B1683322-F67C-42CE-9CAD-(E-Mail Removed)...
>> L17 contains the Status Date (mm/dd/yyyy). If the date in L17 is seven
>> days
>> older than the date I've manually entered in B3, then M17 should read
>> "Update
>> Needed"; if within seven days from B3, it should read, "Current".
>>
>> I am unable to get my formulas to work. Are there any suggestions?
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto entry of data based on entry of text in another column or fie	Judy Rose	Microsoft Excel Misc	2	21st May 2008 01:14 PM
Auto-fill text multiple times based on initial entry - possible?	=?Utf-8?B?SmVubmEgQg==?=	Microsoft Word Document Management	2	16th Feb 2006 05:26 PM
Auto finish a text entry based on previous text entries	=?Utf-8?B?RGFu?=	Microsoft Access	1	14th Jun 2005 04:21 AM
auto populating text box based on prev text box entry	=?Utf-8?B?UmljaGFyZA==?=	Microsoft Access Form Coding	0	16th Feb 2005 06:09 PM
Aging Date in General Templates Order Entry db	mhill31	Microsoft Access Queries	0	17th Nov 2003 11:04 PM