Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
What is the formula to add 90 days to a range of dates that yields MM/DD/YY as the result in corresponding cells?
Amina,
The answer is yes.
I'm not quite sure what the question is
=[DateColumn]23 + 90
will add 90 days (calendar days) to the date in row 23 of the Column named DateColumn.
Drag copy or copy / paste the formula to the other cells in the same column to their own date+90 results.
The formatting of the date fields are based on your selection of Language(Country) in your Account | Personal Settings | Profile section.
The English (United States) uses that formatting.
If you are most in most of other places in the world, the format will be DD/MM/YY.
Are you trying to have DD/MM/YY in one column and MM/DD/YY format in a second column?
Hope this helps.
Apologies for my confusion.
Craig
