come calcolare i giorni fra due date
Salve a tutti .Chiedo se c'è una formula su numbers che possa calcolare i giorni che trascorrono fra due date . grazie
MacBook Pro 15″, macOS 13.0
Question marked as
Just subtract the two dates.
If date 1 is in B2 and date 2 is in C2 then in D2 you could just use
=C2-B2
to get the difference in days expressed as a Duration.
If you need to make further calculations using the number of days then in D2 use
=DUR2DAYS(C2-B2)
In Italian:
=DUR.GIORNI(C2−B2)
SG