Weedays only

[ShouldBEasy]

Hi!

If I have the following:

=DATE(YEAR(Y17),MONTH(17)+3,DAY(Y17))

How can I have the cell only display weekdays. So in the event the above formula gives me a date that falls on Saturday or Sunday I need the cell to give me back the following Monday?

Thanks.

[DGagnon]

Hi there, give this a try

=DATE(YEAR(Y17),MONTH(Y17)+3,DAY(Y17))+LOOKUP(WEEKDAY(DATE(YEAR(Y17),MONTH(Y17)+3,DAY(Y17))),{1,2,3,4,5,6,7},{1,0,0,0,0,0,2})

[daddylonglegs]

You could use EDATE function to add 3 months and then use WORKDAY to ensure the result is a weekday, like this

=WORKDAY(EDATE(Y17,3)-1,1)

[ShouldBEasy]

Perfect! Thank you both. I used the Daddylonglegs for my specific need.