+ Reply to Thread
Results 1 to 2 of 2

creating an if statement using the internal date

Hybrid View

Kim Anderson creating an if statement... 01-23-2007, 08:54 PM
daddylonglegs Try ... 01-23-2007, 09:04 PM
  1. #1
    Registered User
    Join Date
    01-23-2007
    Posts
    1

    creating an if statement using the internal date

    I need to create an if statement that says if we have not received a credit 14 days after a date I enter, I need to have it notify me. The only way I can think of doing that would be to tie the if statement to the internal date. Any ideas how to do this? Or am I missing something more simple?
    Thanks for any help with this.
    KA@maytag

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,721
    Try

    =IF(TODAY()-A1>14,"Payment Late","")

    where your date is entered in A1

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1