Add days to date formula

Platform discussions
, ,
1

Hi,
What formula do i need to use to add “Reported date” to “Attend within (days)” to give a new date in “Complete before”?

image

2

Hi @hayley.white , give this formula a try:

FORMAT_DATE(ADD_DAYS({Reported date},{Attend within (days)}),“D MMM”)

image
image1174×213 20 KB

3

Assuming you’re working with Excel or Google Sheets, here’s the graceful move:

Using the DATE Function:
To add days to a date, you can use the DATE() function.
The formula would look like this:
=DATE(YEAR([Reported date]), MONTH([Reported date]), DAY([Reported date]) + [Attend within (days)])

Replace [Reported date] with the actual cell reference for the reported date.
Replace [Attend within (days)] with the cell reference for the days to attend within.

Hope this helpshttps://www.myaarpmedicarehealth.com

4

To add days to a date in Excel, you can use a simple formula. Let’s assume:

  • “Reported date” is in cell A1
  • “Attend within (days)” is in cell B1

To get the “Complete before” date in cell C1, use this formula:

excel

Copy code

=A1 + B1

This formula adds the number of days in cell B1 to the date in cell A1, giving you the new date in cell C1. regarding Mp3juice 20