View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default How to add 30 days to date in another column, including Sat/Sun?

If A1 is submitted date and B1 is the due date, put in B1 put =A1+30

Tyro

"Sherri" wrote in message
...
I am creating a log for a business. I have "Date Invoice Submitted" in
one
column. The next column is "Date Payment Due", which is 30 days after
date
invoice submitted. Can I formulate this to calculate automatically,
including weekend days? Thanks for any help!