Forum Discussion
Converting days to Year and Month
Hello, I've been trying to convert number of days into years and months. I've looked up some formula which tells me that I can use =DATEDIF(0,(cell with no. of days),"Y") to generate the number of ...
vicneoh The syntax for this would be:
=DATEDIF(<start date>, <end date>,"option")where "option" is Y, M or D.