Days between Dates

[Doug]

Does Excel have the ability to calculate the actual number of days
between 2 dates similar to the way AppleWorks does. In apple works if I
enter 2 dates such as May 12, 2006 and June 22, 2006 I can enter the
formula "=A2-A1" and it gives me the number of days between those 2
dates.

Does Excel work similar to this? I've tried 2 other spreadsheet
applications but they can't do this or they use a 360 day year.
Fortunately they refunded my money when I explained why they wouldn't
work for my needs.

I don't want to waste my money if Excel isn't going to work for me. I've
got about 50 spreadsheets I use in my business that are in AppleWorks
and I'm looking to convert to a spreadsheet application that will be
supported in the future and AW is dead.

Thanks,
Doug

 

[Gordon Rainsford]

Does Excel have the ability to calculate the actual number of days
between 2 dates similar to the way AppleWorks does. In apple works if I
enter 2 dates such as May 12, 2006 and June 22, 2006 I can enter the
formula "=A2-A1" and it gives me the number of days between those 2
dates.

Does Excel work similar to this? I've tried 2 other spreadsheet
applications but they can't do this or they use a 360 day year.
Fortunately they refunded my money when I explained why they wouldn't
work for my needs.

I don't want to waste my money if Excel isn't going to work for me. I've
got about 50 spreadsheets I use in my business that are in AppleWorks
and I'm looking to convert to a spreadsheet application that will be
supported in the future and AW is dead.

Yes, Excel does this fine.

 

[Jim Gordon]

Hi Doug,

Excel even supports some of AppleWorks formulas such as @SUM. Often you
do not have to change the way you enter formulas from AppleWorks.

-Jim Gordon
Mac MVP