Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula with current Date
Hello there, I'm trying to create a formula in which the current month is part of the formula but I wanted to be automatically when the month changes instead of typing. =(F8/*8*)*12/E8 How can the date be inserted automatically and still be part of the fomula? thanks for your help- :) -- alfiboy ------------------------------------------------------------------------ alfiboy's Profile: http://www.excelforum.com/member.php...o&userid=21730 View this thread: http://www.excelforum.com/showthread...hreadid=448759 |
#2
|
|||
|
|||
One way:
=F8/MONTH(TODAY())*12/E8 In article , alfiboy wrote: Hello there, I'm trying to create a formula in which the current month is part of the formula but I wanted to be automatically when the month changes instead of typing. =(F8/*8*)*12/E8 How can the date be inserted automatically and still be part of the fomula? thanks for your help- :) |
#3
|
|||
|
|||
=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 On Tue, 6 Sep 2005 17:43:49 -0500, alfiboy wrote: Hello there, I'm trying to create a formula in which the current month is part of the formula but I wanted to be automatically when the month changes instead of typing. =(F8/*8*)*12/E8 How can the date be inserted automatically and still be part of the fomula? thanks for your help- :) |
#4
|
|||
|
|||
You guys rock!! thanks a lot :) -- alfiboy ------------------------------------------------------------------------ alfiboy's Profile: http://www.excelforum.com/member.php...o&userid=21730 View this thread: http://www.excelforum.com/showthread...hreadid=448759 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula IF returning current date | Excel Worksheet Functions | |||
date format within a cell containing a formula | Excel Discussion (Misc queries) | |||
Expired Date Formula | Excel Worksheet Functions | |||
Date formula | Excel Discussion (Misc queries) | |||
How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) |