ok.
So I have a spreadsheet & I'm creating a database.
It has a date at the top of the page in "long date" format. Which would be today's date.
At the beginning of the row it has another date in "short date" - the date that the enquiry is taken.
It has data validation dropdown lists at the end of the row that have an "if" formula attached to them already. There are numerous amounts of them. e.g. =IF($AT16="PH","1","0")
What I need to do is this:
Only if the date of the enquiry equals today's date then it needs to continue with
=IF($AT16="PH","1","0")
Please help!!
So I have a spreadsheet & I'm creating a database.
It has a date at the top of the page in "long date" format. Which would be today's date.
At the beginning of the row it has another date in "short date" - the date that the enquiry is taken.
It has data validation dropdown lists at the end of the row that have an "if" formula attached to them already. There are numerous amounts of them. e.g. =IF($AT16="PH","1","0")
What I need to do is this:
Only if the date of the enquiry equals today's date then it needs to continue with
=IF($AT16="PH","1","0")
Please help!!