How to I calculate 180 days from any date?
 

Answer: How to I calculate 180 days from any date?
 

Calculating 180 days from any date in Microsoft Excel is a simple process. Here are the steps you can follow:

1. Enter the date you want to calculate 180 days from in a cell. For example, let's say you want to calculate 180 days from January 1, 2022. Enter "
   Code:

   ---

   1/1/2022

   ---

   " in a cell.
2. In the cell next to the date you entered, enter the formula "
   Code:

   ---

   =EDATE(A1,6)

   ---

   " (without the quotes). This formula adds 6 months to the date in cell A1, which is equivalent to adding 180 days.
3. Press Enter and the result will be displayed in the cell. In this example, the result will be "7/1/2022", which is 180 days from January 1, 2022.

That's it! You can now use this formula to calculate 180 days from any date in Excel.

How to I calculate 180 days from any date?
 

=A1+180
Format as date (if needed)
Excel stores dates as serial numbers starting with 1/1/1900 as zero
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jackie" wrote in message
...