Hi there I am subtracting todays date with date past due to get number of days past due... only problme is that some fields in the date past due or empty so i get today's date as a number format returned.
I would only like to subtract today's date with date past due if the cell is not null... don't know how i could go about it since excel does not have any subtraction functions...
Last edited by jgomez; 09-20-2011 at 05:56 PM.
Assuming dates are in the A column starting at A1Also, make sure you format your column containing the formula as a date or it will display a number.
Please Login or Register to view this content.
Last edited by tlafferty; 09-20-2011 at 05:40 PM. Reason: Further explanation
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks