Need help in Excel with date function on a 360 day year

bfrank31 · 12-Oct-2009, 07: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, 09: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 acer asus bios bsod computer crash desktop driver drivers error ethernet excel freeze gaming hard drive hardware hdmi internet laptop malware memory modem monitor motherboard netgear network printer problem ram registry repair router slow software sound toshiba trojan usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless xbox

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

Search
Search for:

Find the solution to yourcomputer problem!

Find the solution to your
computer problem!