#NUM! error

		Microsoft Office Forums > Microsoft Excel > Excel
#NUM! error

FAQ

Thread Tools

Display Modes

02-01-2014, 05:16 PM

jimboba

Windows 7 64bit #NUM! error

Office 2010 64bit

Novice

Join Date: Feb 2014

Posts: 6

#NUM! error

=INT(DATEDIF(J5,J3,"d")/7)&" Weeks "&MOD(DATEDIF(J5,J3,"d"),7)&" Days"

Cell J3 is a date in the future manually entered
Cell J5 is the date today generated by =TODAY()
Cell J7 has the above formula which shows weeks and Days between the two dates.

This all works fine until the date in J3 is less than todays date ie yesterdays date or any date in the past.
in which case Cell J7 shows the above error. I would like that cell to display the message "Expired"
Help appreciated. thanks

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automation error Unknown error" message once they open the Excel file	hlina	Excel	1	10-08-2013 09:14 PM
Word Visual Basic error - run time error 504	crazymorton	Word	11	01-13-2012 04:32 AM
Microsoft office 2010 error 2908 and error 1935 !!!!!!heeeeellpppp!!!!!!!!!	bennypryde	Office	1	01-05-2012 03:33 PM
Runtime error 5487 - Word cannot complete the save to to file permission error	franferns	Word	0	11-25-2009 05:35 AM
Receive error cannot open this form because an error occurred in BCM 2007	bornhusker	Outlook	0	06-01-2009 10:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:03 PM.