Days(360) function

D

Dave

I have a days(360) function, is there a days(365) function? Not sure what
'Method' really means. Guess I could convert each date to a serial number
and subtract.

Appreciate any suggestions.
Thx
Dave
 
N

Niek Otten

Hi Dave,

You don't have to convert; dates ARE serial numbers.

So =A2-A1 gives you the number of days between the two.

BTW, "method" is described in HELP

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a days(360) function, is there a days(365) function? Not sure what
| 'Method' really means. Guess I could convert each date to a serial number
| and subtract.
|
| Appreciate any suggestions.
| Thx
| Dave
|
|
 
D

Dave

Good grief -
Well, thank you Niek -

Everything is simple when you know how do it. I obviously didn't. I looked
all over help but didn't see it pointed out that clearly. Have trouble
calling anything not in quotation marks a string.

Anyway - thank you very much - I'm off and running.

Dave
 
Top