| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count specific No. of dates
Hi.
I have a small excel 2007 file with 5 columns as S#, Date of Xmer damaged, Expected date of completion, No. of Xmers repaired today. I want to display No. of Xmers repaired as per the date of today. I want to see the No. of Xmers repaired each day i log in on my computer with current date i.e. today. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count specific No. of dates
=SUMIF(B:B,TODAY(),D:D)
-- __________________________________ HTH Bob "Shujjat Rasool" <Shujjat wrote in message ... Hi. I have a small excel 2007 file with 5 columns as S#, Date of Xmer damaged, Expected date of completion, No. of Xmers repaired today. I want to display No. of Xmers repaired as per the date of today. I want to see the No. of Xmers repaired each day i log in on my computer with current date i.e. today. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - count the number of records between two specific dates. | Excel Worksheet Functions | |||
| Sumproduct count between dates for specific day | Excel Discussion (Misc queries) | |||
| count occurrence between two specific dates | Excel Discussion (Misc queries) | |||
| Count Specific word in specific range | Excel Worksheet Functions | |||
| Count If Specific word in specific range | Excel Discussion (Misc queries) | |||
Linear Mode
