Share via

Help with Excel formula

Anonymous
2024-09-04T21:45:34+00:00

I need help with a formula. I need to be able to pick a date in one column (the last visit by an agency RN) and then in the second column I need it to auto-populate for the date 14 days from the entered date. So, date of last RN visit + 14 days = date of next required RN visit. I am using an online version so I am not able to use any developer tools. I also can't share the spreadsheet because of HIPAA laws. I am really hoping someone can help!

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2024-09-06T09:00:55+00:00

    Format the cell with the formula as a date.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-09-05T21:50:03+00:00

    Thank you so much for your help! I just have one other question. When I apply the function, it is returning a 5-digit number. Is there a way to ensure that it shows the DATEVALUE instead?

    Was this answer helpful?

    0 comments
  3. HansV 462.6K Reputation points
    2024-09-04T21:59:03+00:00

    Let's say you enter the last visit date in D2 and down.

    Enter the following formula in (for example) E2, then fill down as far as you want:

    =IF(D2="", "", D2+14)

    Was this answer helpful?

    0 comments