Results 1 to 6 of 6

difference between two dates

Threaded View

  1. #1
    Registered User
    Join Date
    11-15-2011
    Location
    riyadh, ksa
    MS-Off Ver
    Excel 2007
    Posts
    3

    difference between two dates

    Hi... new here and need some help with my worksheet
    on column C, i need the difference (from date of admission and discharge) / i used the formula =datedif(d-c) and =d-c / all didnt work; also it would be best if the result highlights less than 2 days. On the column e, i would need the difference between discharge date and dictate date / much similar to the previous columns, and highlight the result of more than 30 days; so it will be easier to recognize the files that are incomplete.

    appreciate if anyone can help me out

    thank you
    Attached Files Attached Files

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