Calculate date from two variable fields, with no #value error in empty rows

		Microsoft Office Forums > Microsoft Excel > Excel
Calculate date from two variable fields, with no #value error in empty rows

FAQ

Thread Tools

Display Modes

09-21-2023, 09:02 AM

wsnow

Windows 10 Calculate date from two variable fields, with no #value error in empty rows

Office 2019

Novice

Join Date: Sep 2023

Posts: 24

Fantastic!
Can you explain to me what is different about the formula you wrote that got rid of the error message? I deleted my old formulas but pretty sure at least one version I tried had the ISNUMBER function instead of ISBLANK, and it still didn't resolve the error message issue.
Thanks.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Error handling input to a Date variable	CuriousG	Excel Programming	2	04-05-2022 08:51 AM
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge	Berryblue	Mail Merge	1	11-13-2014 05:36 PM
Run-time error 91 object variable or with block variable not set	JUST ME	Word VBA	4	03-25-2014 06:56 AM
Run-time error '91': Object variable or With block variable not set	tinfanide	Excel Programming	2	06-10-2012 10:17 AM
30+ days Variable Day Date Calculations via Fields	ztag	Word	2	01-06-2012 11:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:34 PM.