Get instant live expert help on I need help with excel subtract days from date
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I am want to subtract 3 business days from a cell with a date in it.
Solved by T. H. in 25 mins
Can you subtract a date from another date to see how many days late something is, whilst using the weekday function?
Here is the function currently have.
=IF(OR(ISBLANK(B3),ISBLANK(P3)),"",P3-B3)
Solved by E. E. in 26 mins
I am trying to come up with a formula for a Dashboard.
IF STAGE 1 DATE is > STAGE 2 DATE in my table SUBTRACT STAGE 1 DATE and TODAY then get the average days in STAGE 1. BUT if STAGE 1 DATE is < STAGE 2 DATE in my table THEN get the AVERAGE DAYS between STAGE 1 DATE and STAGE 2 DATE.
I have loaded my Soreadsheet
Solved by E. U. in 11 mins
Need help on how to subtract dates in excel. Whenever I subtract dates on a table the returning value is not the number of days. It returns numbers in date form. Ive tried using the DATEIF function as well and it still does not tell me the days.
Solved by X. E. in 27 mins
Hi I am trying to calculate days but accounting for blank cells. If both blank do nothing, if both valued subtract. I got that part but trying concatenate with third option,,,, one has date other doesnt so i want to subtract from todays date. I think i am close, any help is appreciated. The aprt before the middle OR works
=IF(OR(ISBLANK(O5),ISBLANK(P5)),"",O5-P5 ) OR IF((ISBLANK(O5),P5="*")),Today() - P5,)
Solved by T. C. in 22 mins