+ Reply to Thread
Results 1 to 4 of 4

Calculate date based on multiple cells

  1. #1
    Valued Forum Contributor scaffdog845's Avatar
    Join Date
    02-01-2008
    Location
    Aston, PA. USA.
    MS-Off Ver
    Microsoft 365
    Posts
    373

    Calculate date based on multiple cells

    I'm trying to figure out a formula for (K2) that would insert a date if 2 conditions were met.

    1st condition cell (P2) is blank
    2nd condition Today's date is at least 30 days beyond the date in cell (F2)

    The resulting date needs to be either cell (F2) plus 30 days or the date of the current weeks Monday if that Monday's date is more recent than cell (F2) plus 30.

    I've figured out some fairly out there formulas, but this one is a bit beyond my expertise.

    Thanks for the help.
    Attached Files Attached Files

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    Hi scaffdog,

    Perhaps this formula will work for you:
    Please Login or Register  to view this content.

  3. #3
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    Correction to the formula above. That was returning the incorrect date. Try:
    Please Login or Register  to view this content.

  4. #4
    Valued Forum Contributor scaffdog845's Avatar
    Join Date
    02-01-2008
    Location
    Aston, PA. USA.
    MS-Off Ver
    Microsoft 365
    Posts
    373
    Seemed to work in the example I posted. I'll try it in the full spreadsheet.

    Thanks Paul.

    Steve

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 15
    Last Post: 07-23-2008, 06:59 AM
  2. Creating a Gantt based on values in cells
    By vjboaz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-10-2008, 09:50 AM
  3. Percentage discount based on todays date....
    By dawgpoundfan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-09-2008, 06:05 PM
  4. Locating the latest date in multiple worksheets within a workbook.
    By kcurrie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-08-2008, 08:12 PM
  5. date, link n calculate
    By hyerim in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-21-2008, 11:49 PM

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