Thread
:
calculating dates
View Single Post
#
3
Posted to microsoft.public.excel.misc
Roger Govier[_3_]
external usenet poster
Posts: 2,480
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?
Reply With Quote
Roger Govier[_3_]
View Public Profile
Find all posts by Roger Govier[_3_]