Hello, I have modified the EOMONTH formula with a WEEKDAY function. However, after I add WEEKDAY and add a parenth, the return is a date but it is in 1900 so I think I have done something wrong. Do you see what is the issue? I also want to add days to this formula and not certain where exactly to add the days. The days added needs to also take into account if lands on a weekend then go to the next weekday.
this is how I have it now. I added the WEEKDAY part.