Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-02-2024, 11:48 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline datedif() Windows 10 datedif() Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Quote:
Originally Posted by Pablo2000 View Post
Putting =DATEDIF(DATESERIAL(2023,1,1),DATESERIAL(2024,1,1) ,"M") into a cell gives me #NAME?
DATESERIAL is an ACCESS or VBA function. DATEDIF ( with one "F") is the way to go ( among others)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #2  
Old 10-03-2024, 02:55 AM
ArviLaanemets ArviLaanemets is offline datedif() Windows 8 datedif() 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

Quote:
Originally Posted by Pecoflyer View Post
DATESERIAL is an ACCESS or VBA function. DATEDIF ( with one "F") is the way to go ( among others)
Sorry! Somehow forgot, that the post wasn't about programming!
So
Code:
=DATEDIF(DATE(2023,1,1),DATE(2024,1,1),"m")
And why can't MS have unified naming conventions? The functions with identical names do something different, the functions which do the same thing, are named differently! Very confusing!

Last edited by ArviLaanemets; 10-03-2024 at 05:05 AM.
Reply With Quote
  #3  
Old 10-03-2024, 07:54 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline datedif() Windows 10 datedif() Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Quote:
Originally Posted by ArviLaanemets View Post
And why can't MS have unified naming conventions? The functions with identical names do something different, the functions which do the same thing, are named differently! Very confusing!
Perhaps to avoid confusion as the DATEDIFF and the DATEDIF ( not supported by MS anymore) functions have very different syntaxes?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
DATEDIF issue teza2k06 Excel 2 11-14-2021 03:35 AM
datedif() Using DateDif Function OTPM Project 5 03-17-2014 05:16 AM
datedif() Help with DATEDIF Formula caz46 Excel 7 01-12-2012 08:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft