Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008
    Posts
    150

    Unanswered: Help with Changing Dates using ABS Formula

    Hello,

    I have been trying to create a template that adds a number of days to a date that is entered, but I don't know how to get the dates to calculate.

    I have attached a sample of my spreadsheet for the brave individual who takes on this challenge. :-D

    I have absolute values in Row 1. I would like rows 3 thru whatever to calculate based on the ABS formula.

    I really hope someone can help me. Thank you.
    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    rather than try and explain what you want to do with functions that aren't doing the job you require why not try to explain what it is you want to do in English
    I don't understand the relevance of the ABS function call at all
    if 'all' you want to do is subtract 93 days from the date in then
    {cellref} -100+7
    if the source cell is A8 then
    =A8-100+7
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •