Menu

SUM based on Date < TODAY()

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Posted to microsoft.public.excel.misc

Maistrye

Maistrye is offline

external usenet poster

Posts: 1

Default

SUM based on Date < TODAY()

Wrote:
Hi All,

I need some help on a worksheet I am creating, basically it is a
simple
sheet to keep track of employees holidays.

I simply have a row at the top containing a list of dates, (individual
dates) until the end of the current year.

Then I have a column containing the employees name, and under each
day,
if the employee has booked holidays for that day, then I simply mark
it
with either a 1 or a 0.5 representing full or half days.

What I want to do is create a cell which calculates the number of days
the employee has already taken. (i.e Previously) How can I do a sum of
the row, which includes the holiday information, but only upto
TODAY()?

If I am not clear I appologise, if I am i look forward to your
suggestions.

Kind Regards
Mick Walker

You indicated your date info is in the first row

=SUMPRODUCT(--($A$1:$Z$1<TODAY()),A2:Z2)

If you want to include today, change the "<" to "<="

Scott

--
Maistrye
------------------------------------------------------------------------
Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078
View this thread: http://www.excelforum.com/showthread...hreadid=562382

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatically filling date of today (without it changing tomorrow)	Jaydubs	Excel Discussion (Misc queries)	5	June 27th 06 05:11 PM
How to return a value between date ranges	Mary-Lou	Excel Worksheet Functions	7	May 26th 06 10:00 PM
Calculate Start Dates based on Need-By Date?	GB	Excel Worksheet Functions	2	February 21st 06 06:11 PM
Show a date based on today	DJ Dusty	Excel Worksheet Functions	2	November 12th 04 03:20 AM
Show a date based on today	DJ Dusty	Excel Worksheet Functions	1	November 11th 04 10:28 PM

All times are GMT +1. The time now is 03:54 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement