datedif()

10-02-2024, 11:48 PM

Pecoflyer

Windows 10 datedif()

Office 2021

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 08:18 PM.