Help!
I need a formula to calculate a running date (todays date) minus a previous date to give the number of days in between.
And one for the same without the Saturday and Sundays if possible?
Any help much appreciated.
Regards,
SS
Excel Formula
Moderator: Moderators
- Safetysmurf
- Snr Member
- Posts: 352
- Joined: Fri Apr 11, 2014 2:51 pm
- 10
- Industry Sector: Construction and Manufacturing
- Occupation: Group Safety,Health and Environment Manager
- Location: East Yorkshire
- Has thanked: 7 times
- Been thanked: 31 times
- Coolcat
- HSfB Moderator
- Posts: 5924
- Joined: Tue Sep 12, 2006 3:58 pm
- 17
- Industry Sector: Plastic Manufacturing
- Occupation: SHE Manager
- Location: Sunny Kent
- Has thanked: 1 time
Re: Excel Formula
Hi, this will give you the number between two dates, not sure how you would take out the weekends
=(DAYS360(O7,C7))/365
=(DAYS360(O7,C7))/365
In the depth of winter, I finally learned that within me there lay an invincible summer.
--Albert Camus
--Albert Camus
- grim72
- Anorak Extraordinaire
- Posts: 689
- Joined: Fri Aug 20, 2010 3:53 pm
- 13
- Twitter: goodtogosafety
- Industry Sector: Safety inspection systems
- Location: UK
- Has thanked: 4 times
- Been thanked: 81 times
- Contact:
Re: Excel Formula
When it comes to figuring out how to do something on Excel I usually post my requirement on https://www.excelforum.com/ and some bright spark will give me the solution within a few minutes, 9 times out of 10. Has saved me hours of work in the past so would highly recommend the forum.
Grim72
Good to Go Safety - Providing you with a safer workplace
Before you criticize someone, you should walk a mile in his shoes. That way, when you criticize him, you're a mile away and you have his shoes
Good to Go Safety - Providing you with a safer workplace
Before you criticize someone, you should walk a mile in his shoes. That way, when you criticize him, you're a mile away and you have his shoes
- Safetysmurf
- Snr Member
- Posts: 352
- Joined: Fri Apr 11, 2014 2:51 pm
- 10
- Industry Sector: Construction and Manufacturing
- Occupation: Group Safety,Health and Environment Manager
- Location: East Yorkshire
- Has thanked: 7 times
- Been thanked: 31 times
Re: Excel Formula
Thanks for the help guys.
I found it in the end with the help of google and 1.5 hrs persistence of trying.
The formula i used for working days since an accident =NETWORKDAYS(C4,D4) with C4 being the date of the accident and D4 being todays date and format cells to the full column to general
Days since an accident =DATEDIF(C4,D4,"d")
D4 needs to be set to =NOW()
You input the accident date in C4
Thanks,
I found it in the end with the help of google and 1.5 hrs persistence of trying.
The formula i used for working days since an accident =NETWORKDAYS(C4,D4) with C4 being the date of the accident and D4 being todays date and format cells to the full column to general
Days since an accident =DATEDIF(C4,D4,"d")
D4 needs to be set to =NOW()
You input the accident date in C4
Thanks,
- Alexis
- Official HSfB Legend
- Posts: 48845
- Joined: Thu Mar 18, 2004 10:52 am
- 20
- Twitter: https://twitter.com/AlexisHSfB
- Location: West Lothian
- Has thanked: 2821 times
- Been thanked: 340 times
- Contact:
Re: Excel Formula
Many thanks Siftersam.Siftersam wrote: ↑Fri Jun 30, 2017 3:54 pm This is an excellent reference website with clear examples
https://exceljet.net/formulas
"A candle loses none of its light by lighting another candle."
Hundreds of FREE Health & Safety Downloads Here
Hundreds of FREE Health & Safety Downloads Here
Re: Excel Formula
I was trying to come up with a similar formula a few weeks back, wish I'd have seen this sooner, doh! Good info guys