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

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
You should just be able to subtract the two, the result will be the number of days.
 
Upvote 0
Assuming today's date in A1, perhaps:

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

Format as General.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,272
Members
448,558
Latest member
aivin

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
Back
Top