Hey all,
My sheet is working with 3 possible sources for dates, Call them Column A and Column B (each row will have one or the other but not both) and Column C (which every one will have and is always a later date than Either A or B). I am trying to have Column D Pull dates from A or B depending if one is blank and provide the difference with Column C. Been trying to make =IF(A5="","",(DATEDIF(B5,C5,"D"))) work however it returns a 42810 value
Hi, welcome to the forum
I would do this as follows (based on the formula you gave)...
=DATEDIF(if(a5="",B5,a5),C5,"D")
What you need to understand about dates and times in excel is…
a date is just a number representing the number of days passed since 1/1/900...and then formatted in a way that we recognize as a date. So, for instance, today (Mon 17 Sep 2018) is actually 43360
Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75
So if your answer is 42810, that is actually 3/16/2017
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
That appears to be working perfectly, thank you.
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks