Results 1 to 7 of 7

Calculating Turn Around Time by date

Threaded View

  1. #5
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,677

    Re: Calculating Turn Around Time by date

    You could probably make it simpler by making column A into dates (however displayed) but my solution supposes that you change nothing except add the year to cell A1 only.

    If you don't specify the year then it will assume the current year, so that might be OK now but as soon as you get to 1st jan 2013 it will assume 2013. If you want to control the year change yourself then better to put in in A1 (or use any other cell but change the A1 in the formula)
    Last edited by daddylonglegs; 04-24-2012 at 10:26 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