Results 1 to 5 of 5

Comparing two dates and ignoring blank cells

LinkBack
- LinkBack URL
- About LinkBacks
Thread Tools
- Show Printable Version
- Subscribe to this Thread…
Rate This Thread
- Current Rating
- ‎ Excellent
- ‎ Good
- ‎ Average
- ‎ Bad
- ‎ Terrible
Display
- Switch to Linear Mode
- Switch to Hybrid Mode
- Threaded Mode

Threaded View

12-11-2024, 09:13 AM #2
josephteh

View Profile

View Forum Posts
Forum Expert

Join Date

01-05-2013

Location

Singapore

MS-Off Ver

H&B2019

Posts

4,542
Re: Comparing two dates and ignoring blank cells

Try, =IF(OR(G10="",C29=""),"",IF(G10>C29, "Yes", "No"))
Register To Reply

« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

Calculate days between dates while ignoring blank cells

By BigDaddyZ in forum Excel Charting & Pivots

Replies: 1
Last Post: 08-29-2022, 07:56 PM
Comparing Target and Delivery dates where some fields are blank.

By GreggP in forum Excel Formulas & Functions

Replies: 2
Last Post: 07-29-2022, 10:10 AM
Automatically calculate mean time between list of dates while ignoring blank cells in list

By mbagc in forum Excel Formulas & Functions

Replies: 6
Last Post: 02-20-2020, 12:44 PM
Ignoring Blank Cells But Keeping Index of Non-Blank Cells w/ Data Validation and ScrollRow

By rogerd1 in forum Excel Programming / VBA / Macros

Replies: 3
Last Post: 07-24-2017, 01:41 PM
Excel 2007 : Ignoring Blank Cells

By stellaselectxi in forum Excel General

Replies: 4
Last Post: 10-24-2010, 04:22 PM
Ignoring cells with zero value or blank

By Moshsoft in forum Excel Formulas & Functions

Replies: 3
Last Post: 04-25-2009, 04:13 AM
Comparing dates, but some date fields are blank.

By dgarris in forum Excel General

Replies: 1
Last Post: 02-25-2007, 01:53 AM

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions

You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT -4. The time now is 11:30 PM.

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1