Number of days to date

duck60

New Member
Joined
Feb 23, 2007
Messages
21
Hello. I am trying to write a formula that takes into consideration a start point. Our fiscal year began Jul 1, 2007. Taking that into consideration, I am trying to write a fomula that takes todays date -today() and gives me a number which today is 33, (the number of days between Jul 1 and today.)
Could you help me out. I have a block with todays date in it that updates as soon excel is started. I just need help with the formula.

Thanks for the help and assistance

Doug
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Diffy

Well-known Member
Joined
Dec 22, 2006
Messages
512
You should just be able to subtract the two, the result will be the number of days.
 

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Assuming today's date in A1, perhaps:

=A1-DATE(YEAR(A1)-(MONTH(A1)<7),7,1)+1

Format as General.
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi duck60:

Let me see if I undestand you correctly ...

<html><head><title>Excel Jeanie HTML</title></head><body>
Excel Workbook
ABCD
1TodayDateFiscalYearBeginDate
28/2/20077/1/200733
3
Sheet9


</body></html>

I don't know whether the answer you are looking for is 32 or 33 ... make adjustment to the formula accordingly.
 

Forum statistics

Threads
1,181,416
Messages
5,929,790
Members
436,694
Latest member
dpatete

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top