Hi,
I have a data with three columns
1) Start date
2) End Date
3) No of Days
I want to calculate the date between end date and start date using the excel formula.
My concern is if the start date and end date is half date ie 01-01-2023 12:00:00 PM then the no of days to come as 0.5 but it is coming as 1.5 day.
Need excel formula for calculating half day
Thanks
Webmax
From Date To date No of Days Subtraction
with Power Query
with formula maybe try subtract time not days
Please Login or Register to view this content.
or
to date - from date -1
Last edited by sandy666; 01-04-2023 at 02:03 PM.
Thanks for sharing. But my requirement is in the first sample if the start date is 1/1/2023 and end date is 3/1/2023 then it should come as 3 days.
Try
Formula:
Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
end date is not over yet so it can't be treated as full ended day that is why I said try subtract time not days
Last edited by sandy666; 01-04-2023 at 02:11 PM.
If from date and to date is same date then the no of days should come as 1 but it is come as zero
Last edited by webmax; 01-04-2023 at 02:22 PM.
Try
=(INT(B2)-INT(A2))+MOD(B2,1)+1
subtraction of the same dates = 0 not 1
1-1 = 1 or 0 ? basic math
still i am getting wrong dates using the above formula.
Attaching the excel sheet with different scenarios. i have also added the output required.
Thanks
Webmax
See attached
Try
=(INT(B6)-INT(A6))-MOD(B6,1)-MOD(A6,1)+1
allows for midday START
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks