PDA

View Full Version : spreadsheet formula



31-05-1999, 03:15 PM
In the issue November 1998, your John Walkenbach wrote of a little known formula called =datedif
The syntax for this formula was given as =datedif(start_date,finish_date,units)
I have tried it many ways but each time the formula fails. What am I doing wrong? I am setting up the formula as =datedif(12/12/89,12/12/99,'m')which should give an answer of 120
I am using excel 97.
Yours sincerely
Brian Little