ExcelBanter - if today = then

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - if today = then (https://www.excelbanter.com/new-users-excel/266709-if-today-%3D-then.html)

klaesser

if today = then

Lets say I have four cell A1,A2,A3,A4

A1 contains a date(11/10/10 eg)

A2 contains $ data

A3 is blank

and in A4 I want a formula that asks =IF TODAY is equal to or greater than A1 then A3 is equal to A2 else blank (or 0)

Any help please

Mazzaropi

Quote:

Originally Posted by klaesser (Post 960507)

Lets say I have four cell A1,A2,A3,A4

A1 contains a date(11/10/10 eg)
A2 contains $ data
A3 is blank
and in A4 I want a formula that asks =IF TODAY is equal to or greater than A1 then A3 is equal to A2 else blank (or 0)
Any help please

Dear Klaesser, Good Evening.

Try to use this one:

A3 -- =IF(TODAY()=A1,A2,"")

klaesser

Quote:

Originally Posted by Mazzaropi (Post 960523)

Dear Klaesser, Good Evening.

Try to use this one:

A3 -- =IF(TODAY()=A1,A2,"")

Yes it works, Thank You

All times are GMT +1. The time now is 07:36 AM.