Health and Safety for Beginners Forums

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

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

=(DAYS360(O7,C7))/365

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.

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,

This is an excellent reference website with clear examples

https://exceljet.net/formulas

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.

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