Results 1 to 8 of 8

IF function with date values

Threaded View

paul16451 IF function with date values 06-04-2012, 12:34 PM
Russell Dawson Re: IF function with date... 06-04-2012, 12:59 PM
paul16451 Re: IF function with date... 06-04-2012, 01:09 PM
Russell Dawson Re: IF function with date... 06-04-2012, 01:25 PM
paul16451 Re: IF function with date... 06-04-2012, 01:27 PM
Russell Dawson Re: IF function with date... 06-04-2012, 01:29 PM
paul16451 Re: IF function with date... 06-04-2012, 01:30 PM
Russell Dawson Re: IF function with date... 06-04-2012, 01:31 PM
  1. #1
    Registered User
    Join Date
    06-04-2012
    Location
    Sunnyvale, CA
    MS-Off Ver
    Excel 2016
    Posts
    8

    IF function with date values

    Can someone help me with IF Function formatting for dates? Specifically I'm looking for a way to use the IF Function to post a date of one year (365 days) past the given cell value, or 9/15/2012, whichever is later.

    For example, IF ((A4) + 365) < (TODAY) then return 9/15/12, else return (A4) + 365.

    Having trouble formatting it exactly right to get the value I want, though. Thanks!

    -Paul
    Last edited by paul16451; 06-04-2012 at 12:42 PM. Reason: error in 1st post

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