datedif()

		Microsoft Office Forums > Microsoft Excel > Excel
datedif()

FAQ

Thread Tools

Display Modes

10-02-2024, 11:48 PM

Pecoflyer

Windows 10 datedif()

Office 2021

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,920

Pecoflyer has a reputation beyond repute

Quote:

Originally Posted by Pablo2000

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
DATEDIF issue	teza2k06	Excel	2	11-14-2021 03:35 AM
Using DateDif Function	OTPM	Project	5	03-17-2014 05:16 AM
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 09:51 AM.