Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating dates
I'm wondering if I am able to calculate a date based on two different cells.
A1 is my actual start date 6/28/2006 C1 is the current date (ex 5/13/2009) B1- I want this is be the start date for the person's year at work. so I want it to calculate 6/28/2008. The catch is I can't just go -1 on the year because when the current date is 7/1/2009 (C1) I need B1 to be 6/28/2009 to relect only being 3 days into that work year. Is this possible? If so, how? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating dates
Try this in B1
=C1-MOD(C1-A1,365.25)+1 "future spreadsheet master" wrote: I'm wondering if I am able to calculate a date based on two different cells. A1 is my actual start date 6/28/2006 C1 is the current date (ex 5/13/2009) B1- I want this is be the start date for the person's year at work. so I want it to calculate 6/28/2008. The catch is I can't just go -1 on the year because when the current date is 7/1/2009 (C1) I need B1 to be 6/28/2009 to relect only being 3 days into that work year. Is this possible? If so, how? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating dates
Hi
In B1 =A1-DATE(YEAR(C1),6,28) -- Regards Roger Govier "future spreadsheet master" <future spreadsheet wrote in message ... I'm wondering if I am able to calculate a date based on two different cells. A1 is my actual start date 6/28/2006 C1 is the current date (ex 5/13/2009) B1- I want this is be the start date for the person's year at work. so I want it to calculate 6/28/2008. The catch is I can't just go -1 on the year because when the current date is 7/1/2009 (C1) I need B1 to be 6/28/2009 to relect only being 3 days into that work year. Is this possible? If so, how? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating dates
Sheeloo wrote:
Try this in B1 =C1-MOD(C1-A1,365.25)+1 That will be off by one day in many circumstances. Try it with A1 = 2004/03/01 and today's date in C1. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating dates | Excel Discussion (Misc queries) | |||
Calculating Dates | Excel Worksheet Functions | |||
calculating due dates | Excel Discussion (Misc queries) | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Calculating dates | Excel Discussion (Misc queries) |