G
Guest
I need some help trying to calculate a date.
I have a month end date of 1st April 07. I then have a timetable which
states 1 day later I should do these tasks, 2 days later these other tasks.
I have a formula which calculates the date that these items are due which is
month end date plus 1 for 1 day later, 2 for 2 days later etc. I need to
ensure that the date given does not include Saturday and Sunday. Is there a
formula I can use without manually changing the days later figure?
Thanks
I have a month end date of 1st April 07. I then have a timetable which
states 1 day later I should do these tasks, 2 days later these other tasks.
I have a formula which calculates the date that these items are due which is
month end date plus 1 for 1 day later, 2 for 2 days later etc. I need to
ensure that the date given does not include Saturday and Sunday. Is there a
formula I can use without manually changing the days later figure?
Thanks