Results 1 to 4 of 4

Conbine formula DATEIF with today's date

Threaded View

  1. 02-25-2012, 02:30 PM #1
    Kimston
    Kimston is offline
    Forum Contributor
    Join Date
    02-20-2011
    Location
    Candada
    MS-Off Ver
    Microsoft Office 365
    Posts
    174

    Conbine formula DATEIF with today's date

    Hi everyone,
    I am trying to modify this formula DATEDIF(C2,D2,"m") so it includes today’s date instead of having a designated. Also, I would like to include in a Conditional Formatting to change the color of the cell to green if the value in B2 is equal or greater than 12. Could someone tell the best approach to this problem? See attachment for detail.
    Thank you very much in advance.
    Attached Files Attached Files
    Last edited by Kimston; 02-25-2012 at 06:29 PM. Reason: solved
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1