| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to add 30 days to date in another column, including Sat/Sun?
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to add 30 days to date in another column, including Sat/Sun?
XL stores dates as integer offsets from a base date, so adding 30 days
is just A1: <date B1: =A1 + 30 Format B1 as a date. In article , Sherri wrote: 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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Days between dates including start day and weekends | Excel Worksheet Functions | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
| Auto Fill days of the month (not including weekends) | Excel Worksheet Functions | |||
| I want to count days between two dates including start date | Excel Worksheet Functions | |||
| If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) | |||
Linear Mode
