Date macro or formula

[Fraserj]

I have no experience of excel formulas but want to create one for work with information moving to a 2nd sheet if its been on for over two weeks, so that we still have information surrounding it.

Can anybody please help me with this?

Information	Date
Bla bla bla	03.03.2023

 

[Fraserj]

filtering does not delete formulas, I'm unsure of what you mean.
But, let me try to think .... are you saying when you cut and paste the "FALSE" records to another worksheet there are no more records on the original worksheet?
If that is the case all the records were equal to FALSE and it makes sense you would take all the formulas away to the other worksheet.


Regarding "Is there a way of if there is no date, this will stay blank." you can wrap the formula in another IF statement.

=IF(A2 = "", IF(A2+14>B$1,"Late","Not Late"))

^^ This formula works if the cell is completely empty or if there is a formula that calculates to a "".

It shows up as not late when no date is added with that formula. And no matter what date I put in its not marking as true or late....

It's not late if no date is there.... its false if there is a date.

 

[Fraserj]

filtering does not delete formulas, I'm unsure of what you mean.
But, let me try to think .... are you saying when you cut and paste the "FALSE" records to another worksheet there are no more records on the original worksheet?
If that is the case all the records were equal to FALSE and it makes sense you would take all the formulas away to the other worksheet.


Regarding "Is there a way of if there is no date, this will stay blank." you can wrap the formula in another IF statement.

=IF(A2 = "", IF(A2+14>B$1,"Late","Not Late"))

^^ This formula works if the cell is completely empty or if there is a formula that calculates to a "".

What I can see

20/03/2023
	06/03/2023	FALSE
		Not Late

What I'd want it to be

20/03/2023 =TODAY()	DATE ADDED	KEEP/REMOVE
	03/03/2023	REMOVE
	09/03/2023	Keep
	(No date)	(blank until date is added z change to keep or remove dependent on if within 2 weeks)

 

[awoohaw]

are the words "(No date)" actually in the cell? If they are then the cell is not blank or not equal to "".
Try this formula then:
=IF(IsNumber(A2)=False,"",IF(A2+14>$B1,"Late","Not Late"))
(this is close to the formula I posted above).
If this doesn't work then please tell specifically what is in the cells with no date. And what is the forumula you have been using.

 

[awoohaw]

Additionally,are you inputting the dates as text? Please fix that. I ask because the dates are left aligned above. If it is just your alignment, okay, but it usually indicates a cell is text instead of date or numeric.

 

[Fraserj]

are the words "(No date)" actually in the cell? If they are then the cell is not blank or not equal to "".
Try this formula then:
=IF(IsNumber(A2)=False,"",IF(A2+14>$B1,"Late","Not Late"))
(this is close to the formula I posted above).
If this doesn't work then please tell specifically what is in the cells with no date. And what is the forumula you have been using.

Sorry no where I put no date it is blank.

That works great now!

Thank you for being so patient!

 

[awoohaw]

My pleasure, happy to help!