ExcelBanter - Changing cell if within 365 days?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Changing cell if within 365 days? (https://www.excelbanter.com/excel-discussion-misc-queries/226116-changing-cell-if-within-365-days.html)

KrisP

Changing cell if within 365 days?

Hi,
I need a way of changing the text in a cell if its over 365 days from a date
in a cell A1?

Example - If A1 is 01/06/2008 then cell B2 = yes. If A1 was 01/01/2000 then
B2 = no.

Thanks in advance!

JLatham

Changing cell if within 365 days?

Try a formula such as this in B2
=IF(NOW()-A1365,"Yes","No")

If the date in A1 is more than 365 days in the past, "YES" will appear, but
if it's within the past 365 days, "NO" will appear.

"KrisP" wrote:

Hi,
I need a way of changing the text in a cell if its over 365 days from a date
in a cell A1?

Example - If A1 is 01/06/2008 then cell B2 = yes. If A1 was 01/01/2000 then
B2 = no.

Thanks in advance!

KrisP

Changing cell if within 365 days?

Fantastic! Thanks, thats spot on.

"JLatham" wrote:

Try a formula such as this in B2
=IF(NOW()-A1365,"Yes","No")

If the date in A1 is more than 365 days in the past, "YES" will appear, but
if it's within the past 365 days, "NO" will appear.

"KrisP" wrote:

Hi,
I need a way of changing the text in a cell if its over 365 days from a date
in a cell A1?

Example - If A1 is 01/06/2008 then cell B2 = yes. If A1 was 01/01/2000 then
B2 = no.

Thanks in advance!

All times are GMT +1. The time now is 11:21 PM.