Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calendaring by weeks
I want to create an event calendar in Excel by setting up formulas (event
date minus two weeks for reminder cards), (event date minus six weeks for invitations) based on the end date. Is there an easy way to subtract weeks in the calendar function? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calendaring by weeks
To which calendar function do you refer?
In cells,say the event date is in A2, for the reminder cards in B2 enter =A2-14 and for the invitations in C2 enter =A2-42 -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "labels using an Outlook contact category" icrosoft.com wrote in message ... I want to create an event calendar in Excel by setting up formulas (event date minus two weeks for reminder cards), (event date minus six weeks for invitations) based on the end date. Is there an easy way to subtract weeks in the calendar function? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calendaring by weeks
What I am looking for is a little more complicated. I am using the
=DATE(year, month,day) function. Yes, I can always put in the (-14 or -42) for the day calculaton. What I need is to create a template with about 12 calculations built around an end date, and then be able to plug in various end dates and then see the dependent dates all change. Unfortunately, the way Excel calendaring seems to work, I would have to retype all the dependent calculations with each new date change. Hope this is understandable. Thanks for your help. "Nick Hodge" wrote: To which calendar function do you refer? In cells,say the event date is in A2, for the reminder cards in B2 enter =A2-14 and for the invitations in C2 enter =A2-42 -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "labels using an Outlook contact category" icrosoft.com wrote in message ... I want to create an event calendar in Excel by setting up formulas (event date minus two weeks for reminder cards), (event date minus six weeks for invitations) based on the end date. Is there an easy way to subtract weeks in the calendar function? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calendaring by weeks
Dear Nick,
You are exactly right about my not understanding the date function. I didn't know what I didn't know. I had taken a Microsoft online tutorial which never mentioned the simple subtractin that you showed me. I finally gave your idea a try and Voila! It worked. Thanks for your patience and the link, which I will very much needed. I wish Microsoft offered a more helpful tutorial. "labels using an Outlook contact category" wrote: What I am looking for is a little more complicated. I am using the =DATE(year, month,day) function. Yes, I can always put in the (-14 or -42) for the day calculaton. What I need is to create a template with about 12 calculations built around an end date, and then be able to plug in various end dates and then see the dependent dates all change. Unfortunately, the way Excel calendaring seems to work, I would have to retype all the dependent calculations with each new date change. Hope this is understandable. Thanks for your help. "Nick Hodge" wrote: To which calendar function do you refer? In cells,say the event date is in A2, for the reminder cards in B2 enter =A2-14 and for the invitations in C2 enter =A2-42 -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "labels using an Outlook contact category" icrosoft.com wrote in message ... I want to create an event calendar in Excel by setting up formulas (event date minus two weeks for reminder cards), (event date minus six weeks for invitations) based on the end date. Is there an easy way to subtract weeks in the calendar function? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EARN OVER 9850 DOLLAR in 3 WEEKS !!! | Excel Worksheet Functions | |||
How to calculate in weeks and days? | Excel Discussion (Misc queries) | |||
Calculate weeks cover | Excel Worksheet Functions | |||
calculate weeks from a start date ( not yr weeks) | Excel Worksheet Functions | |||
Weekly data into Calendar Weeks | Excel Worksheet Functions |