Jul 12, 2023 · Hi I need a formula in excel 365 to find the distance in km between two coordinates (longitude ,latitude) I had tried these twos formulas =6371 *...

Oct 6, 2021 · Looking for a formula to extract text from between the 2nd and 3rd dash ("-"). Example: Create a formula to extract the word "pear" apple-orange-pear-guava But ONLY using the functions …

Jul 24, 2023 · Hi! Been scratching my head with this all afternoon - I want to filter a long list to give me unique values, but I want my new list to have 3 spare rows between each item. I have used an …

Jan 19, 2012 · Hi All, I know this is likely to be a basic one however it has in honesty be driving me insane for days now. I regularly use formulas across multiple sheets and everything works …

Jun 25, 2011 · Hi everyone' I am trying to calculate the number of days between two dates (a start and an end date) and also where if the end date is left blank it calculates today as the end date. This is to …

Dec 23, 2024 · Hi guys, I want to calculate the difference between a start date of absence and recovery date. Below is a snip from my current dataset. few things: 1. Datedif doesnt 2. nor subtracting both …

Jan 17, 2022 · Hello, I have formula that automatically calculates the percentage of completion on a project between two dates (the start date and end date). The formula...

Oct 10, 2005 · Hi, I have also used the above solution so thanks for providing that. I am trying to add another if statement to the datedif statement. The additional is IF (F1<> "completed"). Does anybody …

Jul 23, 2012 · Index Match Table - If a Date is between 2 dates, lookup the value in the same row of that date range User4 Jul 23, 2012 U

Mar 13, 2023 · Hi all, I have a simple formula to count the months between two dates: =DATEDIF(H2,J2,"M") I'm struggling to tweak it to count any months, regardless of how many days …