Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I calculate dates and skip a specific weekday?
I want to be able to enter a date in a cell, put in a formula to add 4 days
to it, but have it add 1 more day to it if the resulting date falls on a Sunday. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I calculate dates and skip a specific weekday?
=A1+4+(WEEKDAY(A1)=4)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Excelman" wrote in message ... I want to be able to enter a date in a cell, put in a formula to add 4 days to it, but have it add 1 more day to it if the resulting date falls on a Sunday. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I calculate dates and skip a specific weekday?
Try this:
A1 = some date =A1+4+(WEEKDAY(A1+4)=1) Biff "Excelman" wrote in message ... I want to be able to enter a date in a cell, put in a formula to add 4 days to it, but have it add 1 more day to it if the resulting date falls on a Sunday. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I calculate dates and skip a specific weekday?
One way:
If the start date is in cell A1 =A1+4+(WEEKDAY(A1+4)=1) Regards Trevor "Excelman" wrote in message ... I want to be able to enter a date in a cell, put in a formula to add 4 days to it, but have it add 1 more day to it if the resulting date falls on a Sunday. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I calculate dates and skip a specific weekday?
Perhaps you don't need this here but for a generic formula to add the number
of days in B1 to a date in A1, excluding Sundays =A1-WEEKDAY(A1,3)+INT(7/6*(B1+MIN(5,WEEKDAY(A1,3)))) |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I calculate dates and skip a specific weekday?
I am trying to do basically the same thing except I need to exclude
Saturdays, Sundays and Holidays. Basically the spreadsheet will have a date that is entered (on date when information is entered onto spreadsheet) then there will be another column that must equal the entered date + 4 (excluding the Saturdays, Sundays and Holidays). Please excuse my ignorance as I am really not proficient in Excel...not something I use often. Your help would be greatly appreciated. The column where the date will be entered is "G". "Biff" wrote: Try this: A1 = some date =A1+4+(WEEKDAY(A1+4)=1) Biff "Excelman" wrote in message ... I want to be able to enter a date in a cell, put in a formula to add 4 days to it, but have it add 1 more day to it if the resulting date falls on a Sunday. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I calculate dates and skip a specific weekday?
Hi!
Use the Workday function. =WORKDAY(A1,4,holidays) A1 = some date 4 = number of days to add to the date Holidays is a list of holidays that you want to exclude from the calculation. List these dates in a range of cells: B1 = 1/1/2006 B2 = 1/31/2006 etc =WORKDAY(A1,4,B1:B5) Format the cell as DATE. Biff "DRondeau" wrote in message ... I am trying to do basically the same thing except I need to exclude Saturdays, Sundays and Holidays. Basically the spreadsheet will have a date that is entered (on date when information is entered onto spreadsheet) then there will be another column that must equal the entered date + 4 (excluding the Saturdays, Sundays and Holidays). Please excuse my ignorance as I am really not proficient in Excel...not something I use often. Your help would be greatly appreciated. The column where the date will be entered is "G". "Biff" wrote: Try this: A1 = some date =A1+4+(WEEKDAY(A1+4)=1) Biff "Excelman" wrote in message ... I want to be able to enter a date in a cell, put in a formula to add 4 days to it, but have it add 1 more day to it if the resulting date falls on a Sunday. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtracting dates to get hours... but I want to skip weekends | Excel Discussion (Misc queries) | |||
Skip holidays falling between two dates | Excel Worksheet Functions |