Solved Need Excel 2007 Formula To Determine Current Month

Microsoft Office excel 2007 - upgrade
December 22, 2012 at 16:50:59
Specs: Windows XP
I use column A for dates of referrals to program. I need to calculate wait times from date of referral to date seen Column E. But I want this only for the current month of referrals. So if the month December 2012, I want to be able to calculate only for the December referrals even if there are previous month referrals in colum A

See More: Need Excel 2007 Formula To Determine Current Month

Report •

#1
December 22, 2012 at 17:42:39
✔ Best Answer
Hi

Try this

=IF(MONTH(A1)=MONTH(TODAY()),E1-A1,"")


Report •

#2
December 22, 2012 at 20:55:21
callietoo,

Here's a posting tip:

When posting in a Help forum such as this, please try to use a Subject Line that tells us something about your question. If everyone used a generic Subject Line such as "I Need A Formula" we wouldn't be able to tell one question from another and the Archives would essentially be useless.

I have edited the subject line of your post to show you what I mean. Scan the list of questions in this forum to see the types of Subject Lines that others have used.

Thanks!

DerbyDad03
Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#3
December 23, 2012 at 10:11:33
Thank you for the tip regarding the subject line, it was the first time I posted on this forum.

Report •
Related Solutions


Ask Question