DateAdd function not working properly for me!

dmcfarland9

New Member
Joined
May 15, 2013
Messages
18
Hey guys,

I am using the dateadd funtion to add weekdays to my date, but it appears to be including the weekends as well. Can you help?? I am attempting to add 25 weekdays (Mon-Fri) to the reservation_date field. When I use the funtion below, it returns the date plus 25 days...

Dateadd("W", 25, [reservation_date])

ex:
reservation_date = 3/8/19
Dateadd("W", 25, [reservation_date]) returns 4/2/19 instead of 4/12/19.

Thanks!!
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hello,

Have you tested :

Code:
=WORKDAY(A2,25)
with cell A2 holding your reservation_date ...

HTH
 

Watch MrExcel Video

Forum statistics

Threads
1,099,078
Messages
5,466,489
Members
406,484
Latest member
kaksolver

This Week's Hot Topics

Top