If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

If statement for dates and leave cell blank if no data

Thread starter rentonhighlands
Start date Oct 22, 2018
Tags

blank cell dates days leave

rentonhighlands

Board Regular

Oct 22, 2018

Help with formula
subtract dates
=CA-BG gives me total days but if CA is blank

How can I leave the cell CA blank?

Excel Facts

Will the fill handle fill 1, 2, 3?

Click here to reveal answer

Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Sort by date Sort by votes

JLGWhiz

Well-known Member

Oct 22, 2018

Code:

=If(CA1<>"",CA1-BG1,"")

Last edited: Oct 22, 2018

Upvote 0

You must log in or register to reply here.

Similar threads

Solved

Formula showing FALSE

Replies: 5

Views: 113

Feb 7, 2024

Fluff

Solved

Return one of two dates depending on (numeric) day

Replies: 3

Views: 226

Feb 19, 2024

megera716

Question

Excel formula to add 30 days to a date and ignore blank cells

Replies: 3

Views: 226

Nov 29, 2023

Fluff

Solved

Returning a date in a cell, but leave blank if no date entered

Replies: 8

Views: 315

Apr 4, 2024

Peter_SSs

Solved

IF AND Formula

Replies: 5

Views: 143

Apr 3, 2024

Peter_SSs

Facebook X (Twitter) Reddit Pinterest Tumblr WhatsApp Email Link

Forum statistics

Threads: 1,215,479

Messages: 6,125,043

Members: 449,206

Latest member: Healthydogs

Share this page

Facebook X (Twitter) Reddit Pinterest Tumblr WhatsApp Email Link

Back

Top

If statement for dates and leave cell blank if no data

rentonhighlands

Board Regular

Excel Facts

JLGWhiz

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock