formula length time since

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formula for length of time since date, continuously keeping up t

Formula for length of time since date, continuously keeping up t

resolvedResolved · Urgent Priority · Version 365

Kayla has attended:
Excel Intermediate course

Formula for length of time since date, continuously keeping up t

I am currently trying to create the formula for working out the length of service for each employee, with their start date in one column and the length of the service in the next. I remember that the formula had to have TODAY to ensure it continuously updates when you open it, but cannot work the formula out! Could someone please help :)


 

Excel tip:

Quickly Adding New Worksheets

Want to place a new Excel worksheet before current worksheet. Use keystroke SHIFT+F11

View all Excel hints and tips


Server loaded in 0.1 secs.