IF(AND()) data not populating

		Microsoft Office Forums > Microsoft Excel > Excel
IF(AND()) data not populating

FAQ

Thread Tools

Display Modes

09-26-2021, 07:58 AM

Pecoflyer

Windows 7 64bit IF(AND()) data not populating

Office 2010

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

After trying in C2 =IF(AND($A2>DATEVALUE("30/09/2022"),$B2<DATEVALUE("1/1/2023")),"X"," ") and pulling down

( with my regional settings which are different), no "x" is returned. So I checked manually and none of yoyr dates match the given conditions ( of course they do match when there is an empty cell in col B)

Try the same formula type in the other columns

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Capturing Data and Populating Word Templates	derekb	Word	2	08-12-2019 12:22 AM
Populating Tables with data when available only - Using Mail merge	stevejohhnym	Mail Merge	1	06-25-2019 12:50 AM
Auto Populating Data with Drop Down Menu	vmangano	Excel	4	12-20-2016 09:03 AM
Populating data From one sheet to another, relative rows	mmp	Excel	16	02-08-2016 09:06 AM
Populating Data in New TABs?	Sueade	Excel	2	06-02-2015 09:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:43 AM.