Excel 97, DateAdd Not Working

[dw85745]

I just created a new spreadsheet in Excel 97,
DateAdd is NOT in function list and usage RETURNS >> NoName
I know DateDif (VB6 is DateDiff) was Not included in Excel but does Work in Excel-97.
Any ideas ??

ALSO is there a work around for Macro's in Excel 97 under Win-10,. There is "NO TRUST" available, and M$ in their infinite wisdom stopped Macro use for security reasons,
even though some of us still may work Offline.

 

[Dave Patton]

.DateAdd probably was not part of Excel 97.

What are you trying to do and what is your question.

 

[SpillerBD]

DATEADD is an Access function.
You can call an Access function in VBA using the library.

 

[dw85745]

Thanks you both for responding.
Dave Patton: Just trying to take a date and add N number of days to it to obtain a new date.

SpillerDB
How do you call an Access function via the VBA library from Excel ?

RE: MACROs
I could write some code to do this BUT MS$ has eliminated ALL MACRO use except for the newer version which use TRUST (Excel-97 does NOT have TRUST).
I'm not sure yet, but with the new TRUST that is required for Win-11, MS$ MAY have obsoleted not only all Hardware but Software.

 

[Dave Patton]

Dates 2022.xlsm
	A	B	C	D
1				7
2	01-Dec-2021	08-Dec-2021
3	01-Dec-2021	08-Dec-2021
1b

Cell Formulas
Range	Formula
B2	B2	=A2+7
B3	B3	=A3+D1

 

[SpillerBD]

Thanks you both for responding.
Dave Patton: Just trying to take a date and add N number of days to it to obtain a new date.

SpillerDB
How do you call an Access function via the VBA library from Excel ?

RE: MACROs
I could write some code to do this BUT MS$ has eliminated ALL MACRO use except for the newer version which use TRUST (Excel-97 does NOT have TRUST).
I'm not sure yet, but with the new TRUST that is required for Win-11, MS$ MAY have obsoleted not only all Hardware but Software.

Actually those functions are part of the VBA library. Use the object browser to locate.

 

[SpillerBD]

RE: MACROs
I could write some code to do this BUT MS$ has eliminated ALL MACRO use except for the newer version which use TRUST (Excel-97 does NOT have TRUST).
I'm not sure yet, but with the new TRUST that is required for Win-11, MS$ MAY have obsoleted not only all Hardware but Software.

They are obsoleting unsupported software that has major security risk like the VBA 4.0. XLS and the related formats have other potentential issues that the Office-XML file types avoid (though not the XLSB file format.)
Links to the different Office 2021 purchase (lifetime license) are available at What's new in Office 2021