Date: Auto text entry based on aging

A

Annabelle

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?
 
H

Howard31

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

check date format in regional setting 2
Age computation 1
Dates converted into text 5
Calculating Age (in days) with multiple date formats (including ti 1
user form text box date problems 5
VBA: Copy a date and paste as text 4
Today's Date 1
Forcing a date entry format of dd/mm/yyyy 1

Top