Why is it that this function does not display a date in Google Spreadsheets?
I am trying to display the date that is 6 months from today. Instead, the cell only shows a value like this: 41,797.
It seems that I cannot embed the function call to
today() inside of the
edate function. If I run the
today() function and store it in one cell, and then reference the cell from the
edate() function, ONLY THEN does it work.
Are you not allowed to nest function calls in Google Spreadsheets?