Remember Me?

#1
May 13th 09, 09:11 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: May 2009 Posts: 1
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
May 13th 09, 10:34 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2008 Posts: 793
calculating dates

Try this in B1
=C1-MOD(C1-A1,365.25)+1

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
May 13th 09, 10:46 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2007 Posts: 2,480
calculating dates

#4
May 13th 09, 11:27 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2008 Posts: 915
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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post hmsawyer Excel Discussion (Misc queries) 2 March 31st 08 09:40 PM Anne Excel Worksheet Functions 6 February 7th 08 01:56 AM Ndstc1 Excel Discussion (Misc queries) 2 November 8th 07 09:16 PM [email protected] Excel Discussion (Misc queries) 5 October 26th 05 06:18 PM Bob Phillips Excel Discussion (Misc queries) 1 March 18th 05 10:21 AM

All times are GMT +1. The time now is 12:52 PM.