Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Dates
I would like to have Excel add 7 days to a starting date and display that in
a Date format. What I am doing is scheduling something every week on the same day and didn't want to constantly go to the calendar and look up the following weeks date. Is this even possible ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Dates
If A1 = Start date
B1=A1+7 and format B1 to Date If this post helps click Yes --------------- Jacob Skaria "brewster56" wrote: I would like to have Excel add 7 days to a starting date and display that in a Date format. What I am doing is scheduling something every week on the same day and didn't want to constantly go to the calendar and look up the following weeks date. Is this even possible ? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Dates
brewster56 wrote:
I would like to have Excel add 7 days to a starting date and display that in a Date format. What I am doing is scheduling something every week on the same day and didn't want to constantly go to the calendar and look up the following weeks date. Is this even possible ? Look at "Add dates" in the help file. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Dates
WOW - I would never have thought of that or thought that it could be that
simple. THANK YOU !!!!! "Jacob Skaria" wrote: If A1 = Start date B1=A1+7 and format B1 to Date If this post helps click Yes --------------- Jacob Skaria "brewster56" wrote: I would like to have Excel add 7 days to a starting date and display that in a Date format. What I am doing is scheduling something every week on the same day and didn't want to constantly go to the calendar and look up the following weeks date. Is this even possible ? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating Dates
Thanks Glenn - I didn't know to look there as something like 'Add Dates'.
Lots of great examples - thank you very much ! "Glenn" wrote: brewster56 wrote: I would like to have Excel add 7 days to a starting date and display that in a Date format. What I am doing is scheduling something every week on the same day and didn't want to constantly go to the calendar and look up the following weeks date. Is this even possible ? Look at "Add dates" in the help file. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Dates | Excel Worksheet Functions | |||
Calculating Dates | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
calculating with dates | Excel Discussion (Misc queries) | |||
calculating with dates | Excel Worksheet Functions |