Results 1 to 6 of 6

Need a formula to calculate holidays from start dates to the current date!

Threaded View

  1. #1
    Registered User
    Join Date
    04-16-2010
    Location
    Cardiff
    MS-Off Ver
    Excel 2003
    Posts
    5

    Need a formula to calculate holidays from start dates to the current date!

    Basically, I've a holiday tracker for learners. I have their names in columns a & b, their start dates, then in the top row going across I got the week commencing etc. I need to create a formula that works out how many months it has been since a learner has been here, times that by 1.5 (they get 1.5 days a month holiday) then - (minus) the days they have already taken. is there ANY WAY of doing this? My file is attached.
    Thanks in advance.
    Attached Files Attached Files
    Last edited by De4no; 04-16-2010 at 07:32 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1