Image

Excel Formula

Have some quality recovery time from health & safety and chit chat in here about anything that doesn't fit into any other category.

Moderator: Moderators

Post Reply
User avatar
Safetysmurf
Snr Member
Snr Member
Posts: 350
Joined: Fri Apr 11, 2014 2:51 pm
9
Industry Sector: Construction and Manufacturing
Occupation: Group Safety,Health and Environment Manager
Location: East Yorkshire
Has thanked: 6 times
Been thanked: 29 times

Excel Formula

Post by Safetysmurf »

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
User avatar
Coolcat
HSfB Moderator
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

Post by Coolcat »

Hi, this will give you the number between two dates, not sure how you would take out the weekends

=(DAYS360(O7,C7))/365
In the depth of winter, I finally learned that within me there lay an invincible summer.
--Albert Camus
User avatar
grim72
Anorak Extraordinaire
Anorak Extraordinaire
Posts: 686
Joined: Fri Aug 20, 2010 3:53 pm
13
Twitter: goodtogosafety
Industry Sector: Safety inspection systems
Location: UK
Has thanked: 4 times
Been thanked: 79 times
Contact:

Re: Excel Formula

Post by grim72 »

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
User avatar
Safetysmurf
Snr Member
Snr Member
Posts: 350
Joined: Fri Apr 11, 2014 2:51 pm
9
Industry Sector: Construction and Manufacturing
Occupation: Group Safety,Health and Environment Manager
Location: East Yorkshire
Has thanked: 6 times
Been thanked: 29 times

Re: Excel Formula

Post by Safetysmurf »

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,
Siftersam
Newbie
Newbie
Posts: 9
Joined: Fri Jan 30, 2015 3:59 pm
9

Re: Excel Formula

Post by Siftersam »

This is an excellent reference website with clear examples

https://exceljet.net/formulas
User avatar
Alexis
Official HSfB Legend
Official HSfB Legend
Posts: 48800
Joined: Thu Mar 18, 2004 10:52 am
20
Twitter: https://twitter.com/AlexisHSfB
Location: West Lothian
Has thanked: 2782 times
Been thanked: 334 times
Contact:

Re: Excel Formula

Post by Alexis »

Siftersam wrote: Fri Jun 30, 2017 3:54 pm This is an excellent reference website with clear examples

https://exceljet.net/formulas
Many thanks Siftersam. clapclap clapclap
"A candle loses none of its light by lighting another candle."

Image

Hundreds of FREE Health & Safety Downloads Here
User avatar
MatMan
Student
Student
Posts: 48
Joined: Thu Jul 13, 2017 11:32 am
6

Re: Excel Formula

Post by MatMan »

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 ;)
Post Reply

 

Access Croner-i Navigate Safety-Lite here for free

HSfB Facebook Group Follow us on Twitter Find us on Facebook Find us on on LinkedIn

Terms of Use Privacy Policy