If with multiple And

		Microsoft Office Forums > Microsoft Excel > Excel
If with multiple And

10-23-2020, 12:46 AM

Purfleet

Windows 10 If with multiple And

Office 2019

Expert

Join Date: Jun 2020

Location: Essex

Posts: 345

I think you were just over keen on your brackets

This seems to work

=IF(AND(MONTH($D6)=MONTH(TODAY()),DAY($D6)=DAY(TOD AY())),"��","")

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combine Multiple Documents from Multiple Folders while also inserting title	Lumberjax	Word VBA	14	03-07-2023 07:12 AM
Mail Merge Student Transcript - Multiple Years from multiple sheets	aizah2018	Mail Merge	1	11-11-2018 01:27 AM
Mail Merge to multiple employees in multiple locations as PDF by location	GFiz	Mail Merge	1	05-13-2017 08:01 PM
I need to add multiple values based on multiple criteria in a cell not sure what to do	AUHAMM	Excel	3	10-27-2014 09:11 PM
Copy Multiple Rows to new workbook when multiple criteria is met.	flds	Excel Programming	5	09-30-2014 09:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:14 PM.