Return Blank Result for Date + Days with No Date

WDETR

New Member
Joined
Mar 26, 2020
Messages
2
Office Version
  1. 2013
Platform
  1. Windows
I have over 200 rows (adding daily) and need to identify the Expected Return Date using 21 days from Email Sent (Date).
1615987280563.png

Everything works fine when there is a date in Col N but I can't figure out how to get rid of the 1900-01-21 when the sent date is blank.

Goal: Col O would return a blank result when there is not date in in Col N.
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,986
Office Version
  1. 365
Platform
  1. Windows
HI & welcome to MrExcel.
How about
Excel Formula:
=if(N15="","",N15+21)
 

JamesCanale

Board Regular
Joined
Jan 13, 2021
Messages
165
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Excel Formula:
=if(N15<>"",N15+21),"")
 

WDETR

New Member
Joined
Mar 26, 2020
Messages
2
Office Version
  1. 2013
Platform
  1. Windows
That worked =if(N15="","",N15+21)

Awesome thank you!!!!!!
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,986
Office Version
  1. 365
Platform
  1. Windows
Glad we could help & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,371
Messages
5,641,753
Members
417,234
Latest member
aaryan bl

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top