Bill Due Date

[davidzan]

I have a bill that is due on the 23rd of each month. However, if the date falls on a Saturday or Sunday, the due date is the next Monday. Is there a formula to automatically advance date to the next Monday if the date falls on a Saturday or Sunday? Thanks

 

[Tetra201]

See if the following formula works for you -- it returns the due date based on today's date:

=WORKDAY(EOMONTH(TODAY(),-(TODAY()<=WORKDAY(EOMONTH(TODAY(),-1)+22,1)))+22,1)

 

[davidzan]

See if the following formula works for you -- it returns the due date based on today's date:

=WORKDAY(EOMONTH(TODAY(),-(TODAY()<=WORKDAY(EOMONTH(TODAY(),-1)+22,1)))+22,1)

 

[davidzan]

Thanks for your prompt response. It doesn't give me the solution I'm looking for, but I will tailor your formula to suit my needs. You are a great help!