Help Please - Dates in Excel

  • Thread starter Thread starter baz
  • Start date Start date
B

baz

Please post response and email used here is bogus to prevent spam.
Thanks.

I am trying to create a formula for a fiscal year showing %time passed
and %time left.
The fiscal begins on 9/1/2004 and ends on 8/31/2005.
Everyday the sheet will be opened with the days date showing.
I want to also show the % time passed and % time remaining as stated
earlier.

Thanks in advance for your help.
baz
 
Days to go =DATE(YEAR(TODAY())+(MONTH(TODAY())>8)*1,8,31)-TODAY()+1
Days gone =DATE(YEAR(TODAY())+(MONTH(TODAY())>8)*1,8,31)-TODAY()
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fiscal Year Calculations 5
IF Function with Dates 9
Help Please-Counting Filtered Rows 2
Most recent date 1
calculate interest between two dates 1
General numbers lookup from FY-PP-WK-D resulting in MM-DD-YY 3
Fiscal year calsulations for past to future dates. 6
select dates for last fiscal year 3

Back
Top