Hi Ric,
You can easily calculate the number of days between today and a future date in Excel by using a simple formula. Here are the steps:
- First, enter the future date in a cell. Let's say you enter it in cell A1.
- Next, in another cell, enter the following formula: =A1-TODAY()
- This formula subtracts today's date (which is given by the TODAY() function) from the future date in cell A1, giving you the number of days between the two dates.
- The result will be displayed as a number. If you want to format it as a more readable format, such as "X days to go", you can use a custom number format. Right-click on the cell with the formula, select "Format Cells", and then select "Custom". In the "Type" field, enter the following format: "0 ""days to go""" (without the quotes).
That's it! Now you have a cell that displays the number of days between today and the future date, in a readable format.