Formula with current Date

A

alfiboy

Hello there,

I'm trying to create a formula in which the current month is part o
the formula but I wanted to be automatically when the month change
instead of typing.

=(F8/*8*)*12/E8

How can the date be inserted automatically and still be part of th
fomula?

thanks for your help- :
 
G

Gord Dibben

=MONTH(TODAY()) returns 9 for September.

So.........

=(F8/MONTH(TODAY())*12/E8)

Assuming the *8* is the the month in your formula.


Gord Dibben Excel MVP
 

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

Find next Sunday 7
Basing math on duplicate entries in a formula 1
Getting a formula to reflect added columns 10
Calculate Total Hours when Overlapping Occurs 0
Counting multiple occcurrences between date range 3
YTD SUMIF based on current date 3
Cell Referencing 5
Problem with formula for finding last greater than/less than or equal to value 2

Top