Find your solution!

bfrank31 · 12-Oct-2009, 06:00 PM #1

Hi, i am trying to figure out a starting date based on a 360 day year, or 30 day months. I have the following information: End date, and the number of days that I need to go back to calculate the start date. For example: End Date = 9/14/08; Number of days to go back = 180. So the start date that i am looking to return is 3/14/08 (not 3/18/08), which can be verified using the =Days360() function. thank you in advance!

Aj_old · 13-Oct-2009, 08:04 AM #2

Code:

a1=14.05.2008
a2=181
a3=date(year(a2);month(a2)-rounddown(a3/30;0);day(a2)-(a3-rounddown(a3/30;0)*30))

Tag Cloud
access audio black screen blue screen boot bsod connection crash dell desktop driver drivers dvd email error excel firefox hard drive hardware hijackthis internet keyboard laptop malware monitor motherboard network networking outlook problem processor recovery router safe mode screen slow sound spyware trojan upgrade vba video virus vista vundo windows windows 7 windows vista windows xp wireless

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Search
Search for: