Thread: [Solved] datedif()
View Single Post
 
Old 10-01-2024, 10:50 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Or use DATESERIAL() - the formula will work with any local setting then
Code:
=DATEDIF(DATESERIAL(2023,1,1),DATESERIAL(2024,1,1),"M")
Reply With Quote